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: Jan 21, 2016
Posted: 18 Jan 2016 12:46 EST
Last activity: 21 Jan 2016 2:47 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
Updated: 8 years ago
Posted: 19 Jan 2016 14:16 EST
Updated: 19 Jan 2016 14:15 EST
Sadat Saeed (SADATSAEED)
Square BPM Inc.
Sadat Saeed
Square BPM Inc.
CA

Yes, you can use the rollback method to achieve this. Basically you have to mark the start and end of your transaction. 

Before you start operating on first object commit all outstanding transaction. 

Make sure you don't Commit or use "write now" while performing action on your 3 tables.

To see attachments, please log in.
Posted: 8 years ago
Posted: 21 Jan 2016 2:47 EST
Phani Sahukaru (sahup1)
Pegasystems Inc.
Phani Sahukaru
Pegasystems Inc.
IN

>>> Basically you have to mark the start and end of your transaction

  • please refer RULE-OBJ-ACTIVITY WORK- PYUPDATEWORKPARTIESAFTER in ruleset Pega-EndUserUI:07-10-19
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