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
