This discussion is archived
0 Replies Latest reply: Apr 19, 2007 1:36 PM by 543909 RSS

No transaction scope effect.

543909 Newbie
Currently Being Moderated
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?