OpenEJB encountered an unknown system error in container:

[Michael Simons]

Hello,

while running our Stateful Session Bean the following exception is thrown. We eiter do not
understand what's going wrong, nor do we know in which direction to investigate.
Any hints on this are very appreciated:

2009-06-23 16:28:35,738 INFO  [OpenEJB] finished invoking method create
2009-06-23 16:28:35,988 INFO  [Transaction] TX Required: Started transaction
org.apache.geronimo.transaction.manager.TransactionImpl@1333aeb
2009-06-23 16:28:37,050 INFO  [Transaction] TX Required: Committing transaction
org.apache.geronimo.transaction.manager.TransactionImpl@1333aeb
2009-06-23 16:28:37,097 INFO  [Transaction] TX Required: Started transaction
org.apache.geronimo.transaction.manager.TransactionImpl@23ef98
2009-06-23 16:28:37,128 INFO  [Transaction] TX Required: Committing transaction
org.apache.geronimo.transaction.manager.TransactionImpl@23ef98
2009-06-23 16:28:37,191 INFO  [Transaction] TX Required: Started transaction
org.apache.geronimo.transaction.manager.TransactionImpl@26eae2
2009-06-23 16:28:37,738 INFO  [Transaction] TX Required: Committing transaction
org.apache.geronimo.transaction.manager.TransactionImpl@26eae2
2009-06-23 16:28:38,472 INFO  [Transaction] TX Required: Started transaction
org.apache.geronimo.transaction.manager.TransactionImpl@39e7a6
2009-06-23 16:28:40,238 INFO  [Transaction] TX Required: Committing transaction
org.apache.geronimo.transaction.manager.TransactionImpl@39e7a6
2009-06-23 16:28:40,316 INFO  [Transaction] TX Required: Started transaction
org.apache.geronimo.transaction.manager.TransactionImpl@183b1a
2009-06-23 16:28:40,363 INFO  [Transaction] TX Required: Committing transaction
org.apache.geronimo.transaction.manager.TransactionImpl@183b1a
2009-06-23 16:28:54,564 INFO  [Transaction] TX Required: Started transaction
org.apache.geronimo.transaction.manager.TransactionImpl@1237edc
2009-06-23 16:28:54,736 INFO  [Transaction] TX Required: Committing transaction
org.apache.geronimo.transaction.manager.TransactionImpl@1237edc
2009-06-23 16:28:56,361 INFO  [Transaction] TX Required: Started transaction
org.apache.geronimo.transaction.manager.TransactionImpl@1c98fd0
2009-06-23 16:28:56,408 INFO  [Transaction] TX Required: setRollbackOnly() on transaction
org.apache.geronimo.transaction.manager.TransactionImpl@1c98fd0
2009-06-23 16:28:56,408 INFO  [Transaction] TX Required: Rolling back transaction
org.apache.geronimo.transaction.manager.TransactionImpl@1c98fd0
2009-06-23 16:28:56,408 ERROR [Transaction] Unexpected exception rolling back
org.apache.geronimo.connector.outbound.LocalXAResource@1c2b4ec; continuing with rollback
javax.transaction.xa.XAException
        at org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:88)
        at
org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:590)
        at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:483)
        at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:263)
        at
org.apache.openejb.core.transaction.TransactionPolicy.rollbackTransaction(TransactionPolicy.java:183)
        at org.apache.openejb.core.transaction.TxRequired.afterInvoke(TxRequired.java:78)
        at
org.apache.openejb.core.stateful.StatefulContainerManagedTxPolicy.afterInvoke(StatefulContainerManagedTxPolicy.java:57)
        at org.apache.openejb.core.stateful.StatefulContainer._invoke(StatefulContainer.java:488)
        at org.apache.openejb.core.stateful.StatefulContainer.businessMethod(StatefulContainer.java:420)
        at org.apache.openejb.core.stateful.StatefulContainer.invoke(StatefulContainer.java:272)
        at
org.apache.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD(EjbRequestHandler.java:238)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:129)
        at org.apache.openejb.server.ejbd.EjbDaemon.processEjbRequest(EjbDaemon.java:164)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:122)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:84)
        at org.apache.openejb.server.ejbd.EjbServer.service(EjbServer.java:60)
        at org.apache.openejb.server.ServicePool$2.run(ServicePool.java:78)
        at org.apache.openejb.server.ServicePool$3.run(ServicePool.java:101)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
Caused by: javax.resource.spi.LocalTransactionException: Unable to rollback
        at
org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:113)
        at
org.tranql.connector.AbstractManagedConnection$LocalTransactionImpl.rollback(AbstractManagedConnection.java:197)
        at org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:86)
        ... 20 more
Caused by: java.sql.SQLException: rollback() should not be called while in auto-commit mode.
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:2031)
        at
org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:111)
        ... 22 more
2009-06-23 16:28:56,424 ERROR [OpenEJB] The TransactionManager reported an exception while
attempting to rollback the transaction: null
2009-06-23 16:28:56,424 FATAL [ejb]
EJB_OBJECT.BUSINESS_METHOD:MapSCOBean/MapSCOBean:getTourDetails:fa93a0d589f4917f:3e03655e:1220d2d744b:-65db:
OpenEJB encountered an unknown system error in container:
org.apache.openejb.SystemException: javax.transaction.SystemException: null
        at
org.apache.openejb.core.transaction.TransactionPolicy.rollbackTransaction(TransactionPolicy.java:195)
        at org.apache.openejb.core.transaction.TxRequired.afterInvoke(TxRequired.java:78)
        at
org.apache.openejb.core.stateful.StatefulContainerManagedTxPolicy.afterInvoke(StatefulContainerManagedTxPolicy.java:57)
        at org.apache.openejb.core.stateful.StatefulContainer._invoke(StatefulContainer.java:488)
        at org.apache.openejb.core.stateful.StatefulContainer.businessMethod(StatefulContainer.java:420)
        at org.apache.openejb.core.stateful.StatefulContainer.invoke(StatefulContainer.java:272)
        at
org.apache.openejb.server.ejbd.EjbRequestHandler.doEjbObject_BUSINESS_METHOD(EjbRequestHandler.java:238)
        at org.apache.openejb.server.ejbd.EjbRequestHandler.processRequest(EjbRequestHandler.java:129)
        at org.apache.openejb.server.ejbd.EjbDaemon.processEjbRequest(EjbDaemon.java:164)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:122)
        at org.apache.openejb.server.ejbd.EjbDaemon.service(EjbDaemon.java:84)
        at org.apache.openejb.server.ejbd.EjbServer.service(EjbServer.java:60)
        at org.apache.openejb.server.ServicePool$2.run(ServicePool.java:78)
        at org.apache.openejb.server.ServicePool$3.run(ServicePool.java:101)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
Caused by: javax.transaction.SystemException
        at
org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:605)
        at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:483)
        at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:263)
        at
org.apache.openejb.core.transaction.TransactionPolicy.rollbackTransaction(TransactionPolicy.java:183)
        ... 16 more

Kind Regards,
Michael

[David Blevins]

On Jun 23, 2009, at 7:46 AM, Michael Simons wrote:

> Caused by: javax.resource.spi.LocalTransactionException: Unable to  
> rollback
> at
> org
> .tranql
> .connector
> .jdbc
> .ManagedJDBCConnection
> .localTransactionRollback(ManagedJDBCConnection.java:113)
> at
> org.tranql.connector.AbstractManagedConnection
> $LocalTransactionImpl.rollback(AbstractManagedConnection.java:197)
> at  
> org
> .apache
> .geronimo
> .connector.outbound.LocalXAResource.rollback(LocalXAResource.java:86)
> ... 20 more
> Caused by: java.sql.SQLException: rollback() should not be called  
> while in auto-commit mode.
> at  
> net
> .sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:
> 2031)
> at
> org
> .tranql
> .connector
> .jdbc
> .ManagedJDBCConnection
> .localTransactionRollback(ManagedJDBCConnection.java:111)
> ... 22 more

This seems to be the root exception right here.  Looks like the driver  
is complaining that rollback should not be used when the driver is  
setup with auto-commit enabled.  Not familiar with the driver, but  
definitely auto-commit needs to be off for any environment with a  
transaction manager.

Hope this helps!

-David

[djencks]

The tranql wrapper should be dealing with the autocommit state of the  
connection automatically.  Is there any chance your code called  
setAutocommit(true)?  Were there any sql errors before this?

Which tranql wrapper are you using? I expect its the generic one but  
it doesn't hurt to check.

thanks
david jencks

On Jul 1, 2009, at 4:11 PM, David Blevins wrote:

> On Jun 23, 2009, at 7:46 AM, Michael Simons wrote:
>
>> Caused by: javax.resource.spi.LocalTransactionException: Unable to  
>> rollback
>> at
>> org
>> .tranql
>> .connector
>> .jdbc
>> .ManagedJDBCConnection
>> .localTransactionRollback(ManagedJDBCConnection.java:113)
>> at
>> org.tranql.connector.AbstractManagedConnection
>> $LocalTransactionImpl.rollback(AbstractManagedConnection.java:197)
>> at  
>> org
>> .apache
>> .geronimo
>> .connector.outbound.LocalXAResource.rollback(LocalXAResource.java:86)
>> ... 20 more
>> Caused by: java.sql.SQLException: rollback() should not be called  
>> while in auto-commit mode.
>> at  
>> net
>> .sourceforge
>> .jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:2031)
>> at
>> org
>> .tranql
>> .connector
>> .jdbc
>> .ManagedJDBCConnection
>> .localTransactionRollback(ManagedJDBCConnection.java:111)
>> ... 22 more
>
> This seems to be the root exception right here.  Looks like the  
> driver is complaining that rollback should not be used when the  
> driver is setup with auto-commit enabled.  Not familiar with the  
> driver, but definitely auto-commit needs to be off for any  
> environment with a transaction manager.
>
> Hope this helps!
>
> -David
>