[DERBY-2601] Server SQLException error codes are not returned to client

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.10.1.1
• Component/s: Network Client
• Labels: derby_backport_reject_10_9 derby_triage10_9
• Urgency: Normal
• Issue & fix info: Release Note Needed, Repro attached
• Bug behavior facts: Embedded/Client difference
• Assignee: Knut Anders Hatlen
• Reporter: Katherine Marsden
• Created: 02/May/07 16:48
• Updated: 15/Nov/13 08:15
• Resolved: 18/Sep/12 14:24

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.

Issue Links

• is duplicated by: DERBY-5773 SQLException.getErrorCode() returns -1 on client
• is part of: DERBY-310 Document and/or change Derby client code to match behavior with Embedded driver where possible.