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] Created: (DERBY-5063) Embedded driver allows updateBytes() on BOOLEAN column
Date Sun, 20 Feb 2011 20:58:38 GMT
Embedded driver allows updateBytes() on BOOLEAN column
------------------------------------------------------

                 Key: DERBY-5063
                 URL: https://issues.apache.org/jira/browse/DERBY-5063
             Project: Derby
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 10.7.1.1
            Reporter: Knut Anders Hatlen


The following code inserts the value TRUE into the table T on the embedded driver:

        Statement s = c.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
        s.execute("create table t(b boolean)");
        ResultSet rs = s.executeQuery("select b from t");
        rs.moveToInsertRow();
        rs.updateBytes(1, "this is a test".getBytes());
        rs.insertRow();

The client driver fails:

java.sql.SQLException: An attempt was made to put a data value of type 'byte[]' into a data
value of type 'BOOLEAN'.

I believe the client driver is correct, and embedded should be changed to match it.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message