Java Database Connectivity (JDBC)

Hello,

I was trying to use oracle.sql.CLOB to update CLOB types in database. I was able to successfully run the update when I use the connection obtained from normal DriverManager.getConnection method. But have issues when I use a datasource lookup, Am using Websphere as my JDBC provider environ.

The exception I get during the execution of this line is
oracle.sql.CLOB newClob = oracle.sql.CLOB.createTemporary((java.sql.Connection)conn, false, oracle.sql.CLOB.DURATION_CALL);

java.lang.ClassCastException: com.ibm.ws.rsadapter.jdbc.WSJdbcConnection


as my connection is obtained by DataSource.getConnection() method.

Is this a documented limitation of Oracle SQL CLOB class or is there a way I can tweak the code to work.

Am using a oracle 9i thin driver

Thanks

Message was edited by:
caniknow