Derby
  1. Derby
  2. DERBY-2601

Server SQLException error codes are not returned to client

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      Release Note Needed, Repro attached
    • Bug behavior facts:
      Embedded/Client difference

      Description

      ErrorCodes from returned SQLExceptions are not retained in client. e.g. in the example below, client reports an errorcode of -1 instead of 30000. If DRDA allows it would be good for the errorCode to be retained

      [C:/test] java -Dij.showErrorCode=true org.apache.derby.tools.ij
      ij version 10.3
      ij> connect 'jdbc:derby:wombat';
      ij> create table t(i nt, s smallint);
      ERROR 42X01: Syntax error: Encountered "" at line 1, column 18. (errorCode = 30000)
      ij> exit;
      [C:/test] ns start -noSecurityManager &
      [2] 5712
      [C:/test] Apache Derby Network Server - 10.3.0.0 alpha - (1) started and ready to accept connections on port 1527 at 200
      7-04-20 17:36:27.188 GMT

      [C:/test] java -Dij.showErrorCode=true org.apache.derby.tools.ij
      ij version 10.3
      ij> connect 'jdbc:derby://localhost:1527/wombat';
      ij> create table t(i nt, s smallint);
      ERROR 42X01: Syntax error: Encountered "" at line 1, column 18. (errorCode = -1)
      ij>

      Once this has been fixed ErrorCodeTest can be enabled for client.

      1. d2601-1a.diff
        23 kB
        Knut Anders Hatlen
      2. releaseNote.html
        5 kB
        Knut Anders Hatlen

        Issue Links

          Activity

          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12403101 ] Default workflow, editable Closed status [ 12801957 ]
          Knut Anders Hatlen made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Issue & fix info Repro attached [ 10424 ] Release Note Needed,Repro attached [ 10101, 10424 ]
          Fix Version/s 10.10.0.0 [ 12321550 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Labels derby_triage10_9 derby_backport_reject_10_9 derby_triage10_9
          Knut Anders Hatlen made changes -
          Attachment releaseNote.html [ 12545567 ]
          Knut Anders Hatlen made changes -
          Attachment d2601-1a.diff [ 12529700 ]
          Knut Anders Hatlen made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Knut Anders Hatlen made changes -
          Assignee Knut Anders Hatlen [ knutanders ]
          Knut Anders Hatlen made changes -
          Link This issue is duplicated by DERBY-5773 [ DERBY-5773 ]
          Kathey Marsden made changes -
          Labels derby_triage10_5_2 derby_triage10_9
          Kathey Marsden made changes -
          Labels derby_triage10_5_2
          Knut Anders Hatlen made changes -
          Urgency Normal
          Knut Anders Hatlen made changes -
          Bug behavior facts [Embedded/Client difference]
          Issue & fix info [Repro attached]
          Kathey Marsden made changes -
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Affects Version/s 10.3.0.0 [ 12310800 ]
          Kathey Marsden made changes -
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Kathey Marsden made changes -
          Field Original Value New Value
          Link This issue is part of DERBY-310 [ DERBY-310 ]
          Kathey Marsden created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development