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 Kathey Marsden <km...@sbcglobal.net> on 2007/04/20 19:39:42 UTC

Should client error codes for returns SQLExceptions match embedded.

    In converting the errorCode.sql test I noticed that errorCodes from 
returned SQLExceptions are not retained in client.  e.g. in the example 
below, client reports an errorcode of -1 instead of 30000.
Should I file a bug for client to match embedded errorcodes for returned 
SQLExceptions or is this just an expected difference.

Thanks

Kathey


[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>

Re: Should client error codes for returns SQLExceptions match embedded.

Posted by Kathey Marsden <km...@sbcglobal.net>.

Myrna van Lunteren wrote:
>
>  I think the errorCode should possibly (if DRDA supports this)
> be made to match...
>
Thanks Myrna for responding. I forgot all about this one.   I filed 
DERBY-2601 for the issue.

Kathey

Re: Should client error codes for returns SQLExceptions match embedded.

Posted by Myrna van Lunteren <m....@gmail.com>.

On 4/20/07, Kathey Marsden <km...@sbcglobal.net> wrote:
>    In converting the errorCode.sql test I noticed that errorCodes from
> returned SQLExceptions are not retained in client.  e.g. in the example
> below, client reports an errorcode of -1 instead of 30000.
> Should I file a bug for client to match embedded errorcodes for returned
> SQLExceptions or is this just an expected difference.
>
> Thanks
>
> Kathey
IMHO, we've documented that SQLStates may differ between client and embedded.
However, I think the errorCode should possibly (if DRDA supports this)
be made to match...

Myrna