[
http://issues.apache.org/jira/browse/DERBY-1393?page=comments#action_12418457 ]
Knut Anders Hatlen commented on DERBY-1393:
-------------------------------------------
Thanks for the info, Rick! Seems like setObject() with
targetSqlType==JAVA_OBJECT should be supported too, then. For instance, this
works:
PreparedStatement ps = c.prepareStatement
("select aliasinfo from sys.sysaliases where aliasinfo = ?");
ps.setObject(1, new org.apache.derby.catalog.AliasInfo() {
public String getMethodName() {
return "John Cleese";
}
});
ps.executeQuery();
It should also work when targetSqlType is specified.
> 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
