Fail to enlist db connection after rollback

[Melody Siu]

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.