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

Reply via email to