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 31, 2016
Posted: 18 Jan 2016 12:47 EST
Last activity: 31 Jan 2016 12:51 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: 31 Jan 2016 12:50 EST
Updated: 31 Jan 2016 12:51 EST
Lee Pederson (pedel) Engagement Strategy Content Expert & Principal Instructor - LSA
Pegasystems Inc.
US

In the transition of each Obj-Save step check for "StepStatusFail" and Exception.

Also do this for your "Commit" step >> assuming << you are not calling this Activity within a flow.  If in a flow, do NOT use Commit.

If an error is detected, jump to a step that does: Rollback.  

You can also set a Page-Message which will prevent the page from being persisted.

Pega maintains a "Deferred List" so does not auto-commit each Obj-Save.

If however you are using Connect SQL to write to these 3 (external?) tables, that is an entirely different situation.

If so, investigate the use of CMT (Container Managed Transactions).

Note: there is a "Distributed Transactions" chapter within the 7.1 Lead System Architect Pega Academy course.

 

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