db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dyre Tjeldvoll (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1393) PreparedStatement.setObject(Object,int,int) should throw for unsupported types
Date Sat, 10 Jun 2006 13:38:29 GMT
PreparedStatement.setObject(Object,int,int) should throw for unsupported types
------------------------------------------------------------------------------

         Key: DERBY-1393
         URL: http://issues.apache.org/jira/browse/DERBY-1393
     Project: Derby
        Type: Bug

  Components: JDBC, SQL  
    Versions: 10.2.0.0    
 Environment: JDBC 4, jdk 1.6
    Reporter: Dyre Tjeldvoll
    Priority: Minor
     Fix For: 10.2.0.0


>From the javadoc:

Throws:
 ...
    SQLFeatureNotSupportedException - if targetSqlType is a ARRAY, BLOB, CLOB, DATALINK, JAVA_OBJECT,
NCHAR, NCLOB, NVARCHAR, LONGNVARCHAR, REF, ROWID, SQLXML or STRUCT data type and the JDBC
driver does not support this data type

Since Derby doesn't support ARRAY, DATALINK, NCHAR, NCLOB, NVARCHAR, LONGNVARCHAR, REF, ROWID,
SQLXML or STRUCT the method should throw SQLFeatureNotSupportedException if used with any
of these types. Currently a general type conversion exception is thrown:

>>1) testSetObjectNotImplementedARRAY(org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest)SQL
Exception: An attempt was made to get a data value of type 'CLOB' from a data value of type
'2003'.
>>Caused by: SQL Exception: An attempt was made to get a data value of type 'CLOB' from
a data value of type '2003'.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message