In a .Net application, If I want to put some data into an Oracle
database and a Sql Server database I would start a (distributed)Transaction
then insert the data. If everything worked, I would commit the
transaction, and the Oracle and Sql data would commit. If one of them
failed, I would rollback the Transaction, and Oracle and Sql Server would
rollback their data, and it would be as if nothing happened.
I need the same functionality with CA:Gen. I want to
enlist the CA:Gen call in the same transaction, that way if any of the 3 data
inserts fail, all 3 can be rolled-back, or if all succeed, all the data is
committed.