Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Kavitha Jeyamuthurajan (KavithaJ9007)
BB&T

BB&T
US
KavithaJ9007 Member since 2015 3 posts
BB&T
Posted: Jan 18, 2016
Last activity: Mar 3, 2016
Posted: 18 Jan 2016 12:46 EST
Last activity: 3 Mar 2016 8:20 EST
Closed

Database Transaction handling

Hi,

I am trying to insert data into 3 different DB tables in a single transaction using obj-save. If the transaction fails I would like to rollback the entire transaction. Can someone explain how this can be done?

Thanks

Kavitha

 

To see attachments, please log in.
Data Integration

Posted: 8 years ago
Posted: 3 Mar 2016 8:20 EST
Barry Meyer (BarryM93)
Seniorlink

Seniorlink
US

If you had an activity which performed a number of Obj-Save steps on pages and then at the end had a commit step the activity would fail if the commit fails and if the commit fails all the changes are rolled back.

Generally, that activity should have transitions on the obj-save step to a failure handling portion whenever there is an exception on an obj-save operation and one on the commit operation to return a status that the calling process should handle.

 

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice