Question

7
Replies
1472
Views
SatoshiO6673 Member since 2017 9 posts
Okahara
Posted: June 5, 2018
Last activity: June 17, 2018
Closed
Solved

Commit or roll back operation after update results on multiple tables

Hi,

We have multiple tables and want to commit after we make sure Pega is able to update / insert into all tables. If any of them fails for any reasons, then I want all tables to roll back. Let's say, we have following 2 classes:
Sandbox-Data-Customer (Customer table)
Sandbox-Data-Contract (Contract table)

In an activity, if I am able to update or insert into two of them successfully, I commit. If Customer table is updated but Contract table is for some reason unreachable and DML fails, then roll back.

#1. How would I implement such requirement?

#2. Does it make any difference if I am using Obj method or RDB method? In some scenario I would be using RDB method and need to make sure if it is still feasible.

Thanks,

Data Integration
Moderation Team has archived post
Share this page LinkedIn