Posted: 18 Jan 2016 12:46 EST Last activity: 3 Mar 2016 8:20 EST
Database Transaction handling
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?
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.