GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
Windows and .NET
Oracle Services for Microsoft Transaction Server
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 19, 2007 1:36 PM by 543909
No transaction scope effect.
Apr 19, 2007 1:36 PM
Currently Being Moderated
I'm currently using .Net 2.0 and Oracle 9i.
- Microsoft OracleData
- WinXP SP2 Prof.
- OraMTS 18.104.22.168.
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:
- Get VarX from DB2
- insert on DB1
- update on DB2 (change VarX)
- 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?
Track in Communications