[DERBY-1393] PreparedStatement.setObject(int,Object,int) should throw SQLFeatureNotSupportedException for unsupported types

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: JDBC, SQL
• Environment: JDBC 4, jdk 1.6
• Assignee: Knut Anders Hatlen
• Reporter: Dyre Tjeldvoll
• Created: 10/Jun/06 20:38
• Updated: 13/Dec/07 09:04
• Resolved: 10/Jul/06 13:32

Description

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