db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-2601) Server SQLException error codes are not returned to client
Date Tue, 18 Sep 2012 14:19:08 GMT

     [ 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

Mime
View raw message