File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Fail to enlist db connection after rollback
 
Similar Threads
XA DataSource configuration Error/Exception in JBoss
EJB transaction - issue with two-phase commit
JTA, JDBC, Websphere 5.0.2
JBoss XA Transactions
enlist failed while accessing MQ