You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2012/09/18 16:25:07 UTC
[jira] [Resolved] (DERBY-2601) Server SQLException error codes are
not returned to client
[ https://issues.apache.org/jira/browse/DERBY-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen resolved DERBY-2601.
---------------------------------------
Resolution: Fixed
Fix Version/s: 10.10.0.0
Issue & fix info: Release Note Needed,Repro attached (was: Repro attached)
Marking as resolved, since I don't expect any more work on this issue. Also marking it as not for backport because of the behaviour change.
> Server SQLException error codes are not returned to client
> ----------------------------------------------------------
>
> Key: DERBY-2601
> URL: https://issues.apache.org/jira/browse/DERBY-2601
> Project: Derby
> Issue Type: Bug
> Components: Network Client
> Affects Versions: 10.3.1.4
> Reporter: Kathey Marsden
> Assignee: Knut Anders Hatlen
> Priority: Minor
> Labels: derby_backport_reject_10_9, derby_triage10_9
> Fix For: 10.10.0.0
>
> Attachments: d2601-1a.diff, releaseNote.html
>
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira