Two Laptop Bag*
The moose likes EJB and other Java EE Technologies and the fly likes Fail to enlist db connection after rollback Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Fail to enlist db connection after rollback" Watch "Fail to enlist db connection after rollback" New topic
Author

Fail to enlist db connection after rollback

Melody Siu
Greenhorn

Joined: Nov 06, 2003
Posts: 21
Hi,
I am using xa (under wsad for sql server and embedded mq).
I was able to perform xa transaction successfuly.
However, if i have a rollback happened for a xa transaction follow by another xa transaction, the verify first call to use the db connection
(of the next xa tx) will failed when preparing stmt.
Any idea.
Wendy
4/22/04 12:22:31:506 MDT] 5e945e94 XATransaction E J2CA0030E: Method enlist caught javax.transaction.SystemException: Failed to start the transaction association.
at java.lang.Throwable.<init>(Throwable.java)
at java.lang.Throwable.<init>(Throwable.java)
at javax.transaction.SystemException.<init>(SystemException.java:39)
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1917)
at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:494)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:602)
at com.ibm.ejs.j2c.ConnectionEventListener.interactionPending(ConnectionEventListener.java:745)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processInteractionPendingEvent(WSRdbManagedConnectionImpl.java:1446)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:329)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1410)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1381)
...
while trying to enlist resources from datasource myDataSourceJNDIName with the Transaction Manager for the current transaction, and threw a ResourceException.
 
Consider Paul's rocket mass heater.
 
subject: Fail to enlist db connection after rollback
 
Similar Threads
JTA, JDBC, Websphere 5.0.2
EJB transaction - issue with two-phase commit
JBoss XA Transactions
enlist failed while accessing MQ
XA DataSource configuration Error/Exception in JBoss