PreparedStatement.setObject(index, null) fails
The ORACLE thin driver BITES!!!
I tried calling PreparedStatement.setObject(index, null) and I get the following error:
java.sql.SQLException: Invalid column type
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2034)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:2148)
I have and app that run perfectly on two other RDBMS and driver combinations but fails miserably on the ORACLE thin driver. I am unable to us updateable result sets or get Metadata from a result set. It looks like I need to own the "Objects" that I am trying to use for those features of the driver to work (see my previous post). From SQL*Plus I can do everything I need to do with the same userid but it fails using the thin driver APIs. Simple stuff like getPrimaryKeys()...
Does Oracle support this driver? If so how and where. My previous posts garnered zero responses unlike the MySQL mailing lists where you actually get responses from the driver writer. This SUCKS!!