aspose file tools*
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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
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: 6657
    
    5

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 - More SCJP Mocks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: two transactions under the same XA cordinator to the same resource
 
Similar Threads
MDBs and Transactions
Lock while Updating?
resultset problem
Get Updated Record
Some questions on "select for Update"