Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
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 3:36 PM by
No transaction scope effect.
Apr 19, 2007 3:36 PM
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?
This content has been marked as final.
Show 0 replies