• Post Reply Bookmark Topic Watch Topic
  • New Topic

two transactions under the same XA cordinator to the same resource

 
Rasheeem Rashi
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 6663
5
Firefox Browser Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This depends, but not on XA.

What is the transaction isolation level and does T1 commit the updates ?
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!