Skip to Main Content

XA Transaction Rollback from DB Tables

ritbttcsOct 16 2015 — edited Oct 16 2015

Guys,

I have a requirement where i need to insert data in multiple tables. If the insert fails for one of the table , then the transaction should rollback changes in other tables as well.

I am using a XA Datasource with 2-Phase Commit, but transaction rollback is not happening. I am using publish action with routing option as 'Exactly Once' to send the xml to BS for Database inserts. Can you please suggest why this is not happening ?

Thanks,

RB

Comments
Post Details
Added on Oct 16 2015
1 comment
333 views