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

[David Kilzer (JIRA)]

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
         Assigned To: Dimitris Andreadis


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();
        }
        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


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira