db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (DERBY-2943) execute() and executeUpdate() return different SQLState in embedded and network client
Date Tue, 19 Feb 2008 01:02:35 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kathey Marsden resolved DERBY-2943.
-----------------------------------

    Resolution: Duplicate

Duplicate of DERBY-2653. The A0000 exception is the not implemented exception for methods
taking columnNames and columnIndexes.


> execute() and executeUpdate() return different SQLState in embedded and network client
> --------------------------------------------------------------------------------------
>
>                 Key: DERBY-2943
>                 URL: https://issues.apache.org/jira/browse/DERBY-2943
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>         Environment: Linux Fedora Core 6
>            Reporter: Ramin Moazeni
>
> I noticed this issue as part of jdbcapi/statementJdbc30.java conversion to JUnit. The
following
> code snippet returns different SQLState in embedded and network client.
>                         //create a table, insert a row, do a select from the table,
>                         stmt.execute("create table tab1 (i int, s smallint, r real)");
>                         stmt.executeUpdate("insert into tab1 values(1, 2, 3.1)");
>                         /* Next two stmts will fail because there's no auto-generated
>                          * column.  These forms of "executeUpdate()" are tested more
>                          * in the JUnit test, jdbcapi/AutoGenJDBC30Test.java.
>                          */
>                         System.out.println("trying stmt.executeUpdate(String, int[])
:");
>                         int[] columnIndexes = new int[2];
>                         columnIndexes[0] = 1;
>                         columnIndexes[1] = 2;
>                         try {
>                                 stmt.executeUpdate("insert into tab1 values(2, 3, 4.1)",
columnIndexes);
>                         } catch (SQLException ex) {
>                                 BaseJDBCTestCase.assertSQLState("X0X0E", ex);
>                         }
>                         System.out.println("trying stmt.executeUpdate(String, String[])
:");
>                         String[] columnNames = new String[2];
>                         columnNames[0] = "I";
>                         columnNames[1] = "S";
>                         try {
>                                 stmt.executeUpdate("insert into tab1 values(2, 3, 4.1)",
columnNames);
>                         } catch (SQLException ex) {
>                                 BaseJDBCTestCase.assertSQLState("X0X0F", ex);
>                         }
> Using netwrok client, the returned SQL state is 0A000
> Using embedded, the returned SQL state is either X0X0E or X0X0F

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message