Cannot create CLOB.createTemporary() in Sun One server

[Sheenu Pillai]

Hi,
I am trying to insert a Clob data into Oracle (9i) using thin driver. I used the sample code Oracle had suggested to insert Clob data (by creating temporary memory supplied by the driver). As a standalone program it works fine but when I deploy it to Sun One, it gives me a NullPointer exception in CLOB.createTemporary() method. The only difference I can see is, the database connnection used in standalone was Oracle.jdbc.driver.OracleConnection and that of the server was com.sun.enterprise.resource.JdbcXAConnection. Would this be an issue ? If so is their a work around ?
Thanks,
Srini

[ma rege]

Did u get solution?

I am facing same problem

[Naidu Jitta]

createTemporary expects an OracleConnection whereas from datasource we get a lite wrapper around OracleConnection. We need to navigate through the wrappers to get to the physical OracleConnection.

[Abrar Bin Yousuf]

Since you are using oracle specific calls you would need to use their API calls.

You can check more details at:
http://swforum.sun.com/jive/thread.jspa?forumID=114&threadID=22440

[Julian Eduardo de Anquin]

Hi i've been arround with the same error and i've found the workarround.
BLOB tempBlob = BLOB.createTemporary(unwrappConnection(), true,BLOB.DURATION_CALL);
and the unwrappConnection() method
private OracleConnection unwrappConnection() throws SQLException {
org.jboss.resource.adapter.jdbc.WrappedConnection oWConn = (WrappedConnection) oConn;
return (OracleConnection) oWConn.getUnderlyingConnection();
}
and oConn is the connection taken from the datasource.
Hope this helps
Julian de Anquin