[jboss-jira] [JBoss JIRA] Closed: (JBAS-3879) org.jboss.resource.adapter.jdbc.WrappedConnection does not handle early rollbacks properly

org.jboss.resource.adapter.jdbc.WrappedConnection does not handle early rollbacks properly ------------------------------------------------------------------------------------------ Key: JBAS-3879 URL: http://jira.jboss.com/jira/browse/JBAS-3879 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: Management services Affects Versions: JBossAS-4.0.2 Final Environment: Microsoft Windows XP [Version 5.1.2600] java version "1.5.0_07" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_07-b03) Java HotSpot(TM) Client VM (build 1.5.0_07-b03, mixed mode) jTDS-1.2.0 MS SQL Server 2000 SP4 (separate server running WIndows 2003 Server) Reporter: David Kilzer When an "early" rollback is performed (see code example below) using a java.sql.Connection from a JBossAS-managed DataSource, the following stack trace is produced: java.sql.SQLException: rollback() should not be called while in auto-commit mode. at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:1989) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:535) at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:460) at package.MyClass.testWrappedConnectionBehavior(MyClass.java:71) [...] However, when this same code is run without using a JBossAS-managed DataSource, it works with no SQLException being thrown: private void testWrappedConnectionBehavior(DataSource dataSource) { Connection connection = null; try { connection = dataSource.getConnection(); connection.setAutoCommit(false); connection.rollback(); // line 71 } catch (SQLException e) { e.printStackTrace(System.err); } finally { if (connection != null) { try { connection.close(); } catch (SQLException ignored) { } } } } The org.jboss.resource.adapter.jdbc.WrappedConnection class should be able to handle an early rollback properly. This issue originally filed with Spring: http://opensource.atlassian.com/projects/spring/browse/SPR-2862