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 ?