db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2105) Network Client - Column of type CHAR, VARCHAR or LONG VARCHAR contains wrong value after being updated using the updateObject() method with a clob as parameter.
Date Fri, 26 Oct 2007 19:58:50 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12538087
] 

Mamta A. Satoor commented on DERBY-2105:
----------------------------------------

I tried the test case in Embedded mode (the earlier results were from running the program
in client server mode) and similar (not exactly the same) is thrown in Embedded configuration
too (again, this is by testing the supplied sample code against Derby 1.4 using Sun's jdk142)
 
$ java org.apache.derbyTesting.functionTests.tests.lang.DBMetaData2
Exception in thread "main" java.sql.SQLException: An attempt was made to get a data value
of type 'CHAR' from a data value of type 'java.sql.Clob'.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:88)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:94)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:180)
        at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java:2238)
        at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(ConnectionChild.java:154)
        at org.apache.derby.impl.jdbc.EmbedResultSet.dataTypeConversion(EmbedResultSet.java:4522)
        at org.apache.derby.impl.jdbc.EmbedResultSet.updateClob(EmbedResultSet.java:4154)
        at org.apache.derby.impl.jdbc.EmbedResultSet.updateObject(EmbedResultSet.java:3144)
        at org.apache.derby.impl.jdbc.EmbedResultSet20.updateObject(EmbedResultSet20.java:210)
        at org.apache.derbyTesting.functionTests.tests.lang.DBMetaData2.main(DBMetaData2.java:200)

> Network Client - Column of type CHAR, VARCHAR or LONG VARCHAR contains wrong value after
being updated using the updateObject() method with a clob as parameter.
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2105
>                 URL: https://issues.apache.org/jira/browse/DERBY-2105
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>            Reporter: Fernanda Pizzorno
>
> REPRO:
>             Statement stmt1 = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, 
>                     ResultSet.CONCUR_UPDATABLE);
>             Statement stmt2 = conn.createStatement();
>             stmt1.executeUpdate("CREATE TABLE t1 (i int, c char(60))");
>             stmt1.executeUpdate("CREATE TABLE t2 (i int, c clob(1K))");
>             stmt1.executeUpdate("INSERT INTO t1 values (1, 'xx')");
>             stmt1.executeUpdate("INSERT INTO t2 values (1, 'yy')");
>             ResultSet rs1 = stmt1.executeQuery("SELECT * FROM t1");
>             ResultSet rs2 = stmt2.executeQuery("SELECT * FROM t2");
>             if (!rs1.next()) {
>                 System.out.println("Row not found");
>                 return;
>             }
>             if (!rs2.next()) {
>                 System.out.println("Row not found");
>                 return;            
>             }
>             rs1.updateObject(2, rs2.getClob(2));
>             rs1.updateRow();
>             rs1.close();
>             rs1 = stmt1.executeQuery("SELECT * FROM t1");
>             if (!rs1.next()) {
>                 System.out.println("Row not found");
>                 return;
>             }
>             if (!rs2.getString(2).equals(rs1.getString(2))) {
>                 System.out.println("FAIL - wrong value for column 2 expected: " + 
>                         rs2.getString(2) + " but was: " + rs1.getString(2));
>             }
>             rs1.close();
>             rs2.close();        
>             stmt1.close();
>             stmt2.close();
> OUTPUT:
> FAIL - wrong value for column 2 expected: yy but was: org.apache.derby.client.am.Clob@336d8196

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