On Jun 23, 2009, at 7:46 AM, Michael Simons wrote:
Caused by: javax.resource.spi.LocalTransactionException: Unable to rollbackatorg .tranql .connector .jdbc .ManagedJDBCConnection .localTransactionRollback(ManagedJDBCConnection.java:113)atorg.tranql.connector.AbstractManagedConnection $LocalTransactionImpl.rollback(AbstractManagedConnection.java:197) at org .apache .geronimo .connector.outbound.LocalXAResource.rollback(LocalXAResource.java:86)... 20 moreCaused by: java.sql.SQLException: rollback() should not be called while in auto-commit mode. at net .sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java: 2031)atorg .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
