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

    Details

    • Urgency:
      Low
    • Issue & fix info:
      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); }
      1. ReproDerby1191.java
        0.7 kB
        Kathey Marsden
      2. derby-1191_factory_hack_no_commit_diff.txt
        3 kB
        Kathey Marsden
      3. derby-1191_checkForTransactionInProgress_diff.txt
        4 kB
        Kathey Marsden

        Issue Links

          Activity

          Kathey Marsden created issue -
          Kathey Marsden made changes -
          Field Original Value New Value
          Priority Major [ 3 ] Minor [ 4 ]
          Kathey Marsden made changes -
          Derby Categories [High Value Fix]
          Dag H. Wanvik made changes -
          Issue & fix info [High Value Fix]
          Kathey Marsden made changes -
          Priority Minor [ 4 ] Major [ 3 ]
          Kathey Marsden made changes -
          Link This issue relates to DERBY-3319 [ DERBY-3319 ]
          Kathey Marsden made changes -
          Attachment ReproDerby1191.java [ 12415132 ]
          Kathey Marsden made changes -
          Kathey Marsden made changes -
          Kathey Marsden made changes -
          Issue & fix info [High Value Fix] [High Value Fix, Patch Available, Repro attached]
          Kathey Marsden made changes -
          Link This issue is related to DERBY-4350 [ DERBY-4350 ]
          Kristian Waagan made changes -
          Issue & fix info [High Value Fix, Patch Available, Repro attached] [High Value Fix, Repro attached]
          Rick Hillegas made changes -
          Labels derby_triage10_8
          Rick Hillegas made changes -
          Urgency Low
          Kathey Marsden made changes -
          Labels derby_triage10_8 derby_triage10_10 derby_triage10_8
          Issue & fix info High Value Fix,Repro attached [ 10422, 10424 ] Repro attached [ 10424 ]
          Gavin made changes -
          Workflow jira [ 12353537 ] Default workflow, editable Closed status [ 12802005 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Kathey Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Development