Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2084

getTransactionIsolation() in network client should not activate a transaction

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.3.1, 10.2.1.6, 10.3.1.4
    • Fix Version/s: 10.1.3.2, 10.2.2.0, 10.3.1.4
    • Component/s: Network Client
    • Labels:
      None
    • Bug behavior facts:
      Regression

      Description

      getTransactionIsolation() is implemented by means of
      rs = getTransactionIsolationStmt.executeQuery("values current isolation");

      This will activate a transaction. Thus the code snippet

      Connection conn =
      DriverManager.getConnection(url);
      conn.setAutoCommit(false);
      int tx = conn.getTransactionIsolation();
      conn.close();

      will fail with

      java.sql.SQLException: Cannot close a connection while a transaction is still active.
      at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      at org.apache.derby.client.am.Connection.closeResourcesX(Unknown Source)
      at org.apache.derby.client.am.Connection.closeX(Unknown Source)
      at org.apache.derby.client.net.NetConnection.closeX(Unknown Source)
      at org.apache.derby.client.am.Connection.close(Unknown Source)
      at org.apache.derby.client.net.NetConnection.close(Unknown Source)
      at GetTransactionIsolation.test(GetTransactionIsolation.java:12)
      at GetTransactionIsolation.main(GetTransactionIsolation.java:22)
      Caused by: org.apache.derby.client.am.SqlException: Cannot close a connection while a transaction is still active.
      at org.apache.derby.client.am.Connection.checkForTransactionInProgress(Unknown Source)
      ... 7 more

        Attachments

        1. DERBY-2084.diff
          1 kB
          Bernt Johnsen

          Issue Links

            Activity

              People

              • Assignee:
                bernt Bernt Johnsen
                Reporter:
                bernt Bernt Johnsen
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: