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 (JIRA)" <ji...@apache.org> on 2007/05/02 18:48:15 UTC

[jira] Created: (DERBY-2601) Server SQLException error codes are not returned to client

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
            Reporter: Kathey Marsden
            Priority: Minor


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.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2601) Server SQLException error codes are not returned to client

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-2601:
----------------------------------

    Fix Version/s: 10.3.0.0

> 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
>            Reporter: Kathey Marsden
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>
> 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.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2601) Server SQLException error codes are not returned to client

Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Knut Anders Hatlen updated DERBY-2601:
--------------------------------------

    Urgency: Normal

> 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
>            Priority: Minor
>
> 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.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2601) Server SQLException error codes are not returned to client

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-2601:
----------------------------------

    Affects Version/s: 10.3.0.0
        Fix Version/s:     (was: 10.3.0.0)

> 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.0.0
>            Reporter: Kathey Marsden
>            Priority: Minor
>
> 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.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2601) Server SQLException error codes are not returned to client

Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Knut Anders Hatlen updated DERBY-2601:
--------------------------------------

      Issue & fix info: [Repro attached]
    Bug behavior facts: [Embedded/Client difference]

> 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
>            Priority: Minor
>
> 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.
-
You can reply to this email to add a comment to the issue online.