This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes two transactions under the same XA cordinator to the same resource Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "two transactions under the same XA cordinator to the same resource" Watch "two transactions under the same XA cordinator to the same resource" New topic
Author

two transactions under the same XA cordinator to the same resource

Rasheeem Rashi
Greenhorn

Joined: Feb 09, 2010
Posts: 3
Hello,

I was wonderring how the XA-driver will behave, if it is asked to perform an update to a row in a db within the same xa-transaction, where it is asked to perform a read to the same row.

coordinator
|
--T1: asking to update R1
|
--T2: asking to read R1

Will the Xa rollback, deadlock or commit?

Rashi
Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6588
    
    1

This depends, but not on XA.

What is the transaction isolation level and does T1 commit the updates ?


SCJP 6 articles - SCJP 5/6 mock exams - SCJP Mocks - SCJP 5 Mock exam (Word document ) - SCJP 5 Mock exam in Java.Inquisition format
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: two transactions under the same XA cordinator to the same resource
 
Similar Threads
Get Updated Record
MDBs and Transactions
resultset problem
Lock while Updating?
Some questions on "select for Update"