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.