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

Some SQLExceptions, for example those generated from BrokeredStatements, do not print to derby.log even when derby.stream.error.logSeverityLevel=0

    XMLWordPrintableJSON

Details

    • Low
    • Repro attached

    Description

      I found this when working on DERBY-1047. Exceptions thrown using
      org.apache.derby.impl.jdbc.Util.generateCsSQLException()
      do not print to derby.log even when derby.stream.error.logSeverityLevel=0

      For example the attached repro generates an expected exception but does not print the error to the log.

      java -Dderby.stream.error.logSeverityLevel=0 Derby1047

      This causes an expected exception to be thrown but it does not print to the derby.log

      10.2.0.0 alpha
      Apache Derby
      Apache Derby Embedded JDBC Driver
      done creating table
      COL1
      -----------
      1
      2
      PASS: Expected Exception can'tholdable cusror in global xact:Cannot set holdability ResultSet.HOLD_CURSORS_OVER_COMMIT for a global transaction.
      COL1
      -----------
      1
      2
      3

      The code generating the exception is in org.apache.derby.iapi.jdbc.BrokeredStatement

      final void checkHoldability() throws SQLException

      { int holdability = controlCheck().checkHoldCursors(resultSetHoldability); if (holdability != resultSetHoldability) throw Util.generateCsSQLException(SQLState.CANNOT_HOLD_CURSOR_XA); }

      Attachments

        1. ReproDerby1191.java
          0.7 kB
          Katherine Marsden
        2. derby-1191_factory_hack_no_commit_diff.txt
          3 kB
          Katherine Marsden
        3. derby-1191_checkForTransactionInProgress_diff.txt
          4 kB
          Katherine Marsden

        Issue Links

          Activity

            People

              Unassigned Unassigned
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: