[jboss-user] [JCA Development] New message: "Re: feedback on JBAS-7195 (WrappedConnection.checkTransactionStatus throws exception when transaction is marked for roll back)"

Adrian Brock do-not-reply at jboss.com
Tue Feb 23 11:41:19 EST 2010


User development,

A new message was posted in the thread "feedback on JBAS-7195 (WrappedConnection.checkTransactionStatus throws exception when transaction is marked for roll back)":

http://community.jboss.org/message/527970#527970

Author  : Adrian Brock
Profile : http://community.jboss.org/people/adrian@jboss.org

Message:
--------------------------------------------------------------
I don't think you'll break anything, but you'll lose the early notification of the failure.
i.e. in a lot of cases you'll be doing useless work which won't fail until it becomes time to commit/rollback.
That's cpu and resources that could be used by something else.
 
Perhaps you could make it an option in the -ds.xml instead?
 
The check was added to avoid sql operations leaking into the next transaction because of a race with the tx timeout.
This won't happen if the transaction is just MARKED rolled back only. The transaction hasn't completed yet.
 
See JBAS-5080, the race goes something like:
 
a) Thread 1: start running a query
b) Thread 2: timeout -> roll back transaction, which ends the local jdbc transaction
c) Thread 1: original query now reaches the real connection which is in a new local jdbc transaction as far as the jdbc driver is concerned
 
(b) hasn't happened if the JTA transactions is marked rolled back only

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/527970#527970




More information about the jboss-user mailing list