0 Replies Latest reply: Apr 19, 2007 3:36 PM by 543909 RSS

    No transaction scope effect.

    543909
      Hi,

      I'm currently using .Net 2.0 and Oracle 9i.

      - Microsoft OracleData
      - WinXP SP2 Prof.
      - OraMTS 9.2.0.7.

      I have two users/dbs on the same computer server. Something like:

      DB1 = User Id=user1;Password=pws1;Data Source=ladb01
      DB2 = User Id=user2;Password=pws2;Data Source=ladb01

      Using transaction scope, I’m trying to do something like:

      tx_scope_root
      {

      - Get VarX from DB2

      tx_scope1
      {
      - insert on DB1
      - update on DB2 (change VarX)
      }

      tx_scope2
      {
      - update on DB1
      }

      - Verify VarX from DB2 (VarX DIDN'T CHANGE)

      }

      It uses different scopes because it is embedded inside different methods.

      The problem is that only DB1 commit. It seems that DB2 always rollback, without error or exception. I have other scenarios where scope1 is the root scope and it goes through with no problem.

      Does anyone knows why it is happening?