Atomikos Forum

We have an application that starts a transaction, runs some SQL commands and then attempts to suspend the transaction and begin a new one (in order to perform a set of atomic SQL commands that need to be isolated from the previous ones); unfortunately, when the suspend() method is calledweget the following error:

suspend for XID '3139322E3136382E322E35312E746D30303330333030303032:3139322E3136382E322E35312E746D333233' raised -6: the XA resource did not expect this command in the current context
javax.transaction.xa.XAException
    …
    at com.atomikos.datasource.xa.XAResourceTransaction.xaSuspend(XAResourceTransaction.java:960)
    at com.atomikos.icatch.jta.TransactionImp.suspendEnlistedXaResources(TransactionImp.java:488)
    at com.atomikos.icatch.jta.TransactionManagerImp.suspend(TransactionManagerImp.java:423)
    at com.atomikos.icatch.jta.UserTransactionManager.suspend(UserTransactionManager.java:248)
    ...

The application used to work fine with other transaction managers and we are getting this error after switching to Atomikos TrnasactionsEssentials.
Any ideas of what could be wrong here?

Thanks,

Jacopo

After setting auto commit to false on the connection (the default was true) this problem was resolved.

Jacopo