[ http://issues.apache.org/jira/browse/DERBY-1393?page=comments#action_12417821 ]
Rick Hillegas commented on DERBY-1393: -------------------------------------- The system catalogs contain object columns, which are Formatables: sysaliases.aliasinfo syschecks.referencedcolumn syscolumns.columndatatype syscolumns.columndefault sysconglomerates.descriptor sysdepends.dependentfinder sysdepends.providerfinder sysstatistics.statistics systriggers.referencedcolumns If you select these columns and call ResultSet.getObject(), you will see the following behavior: 1) Embedded: You get back the Formatable object that is stored in the column 2) Network and JCC: You get back the result of calling toString() on the Formatable > 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 > Assignee: Knut Anders Hatlen > 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