multiple database connection. how to rollback
-
Today I asked an interview question. Can you please anyone help me. Question is... I am having 3 database connections. SQL, Oracle and DB2. In SQL i am going to update. In Oracel I am going to insert. In DB2 I am going to delete. If anyone operation fails, all need to rollback. How to achieve this, either in .NET or DB side. Expecting your help. Thanks, Karan
-
Today I asked an interview question. Can you please anyone help me. Question is... I am having 3 database connections. SQL, Oracle and DB2. In SQL i am going to update. In Oracel I am going to insert. In DB2 I am going to delete. If anyone operation fails, all need to rollback. How to achieve this, either in .NET or DB side. Expecting your help. Thanks, Karan
Use a Distributed Transaction Coordinator (DTC).