[
https://issues.apache.org/jira/browse/DERBY-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen updated DERBY-2601:
--------------------------------------
Attachment: releaseNote.html
Attaching a release note describing the changes.
Since no one has voiced their support for adding special handling of the mixed
version scenario, I've mentioned the issue in the release notes under
"symptoms". Also, in the "application changes required" section, I've added a
recommendation that both the client and the server are upgraded to 10.10 or
later if the error code is significant to the application.
> 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_triage10_9
> 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
