aspose file tools*
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 Spring in Action this week in the Spring 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Fail to enlist db connection after rollback