It's not a secret anymore!*
The moose likes JDBC and the fly likes WebLogic 81 DataSource and Oracle CLOB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "WebLogic 81 DataSource and Oracle CLOB" Watch "WebLogic 81 DataSource and Oracle CLOB" New topic

WebLogic 81 DataSource and Oracle CLOB

Alex Beekman

Joined: Dec 22, 2004
Posts: 9
I have a StoredProceude that has a Clob as one of the input parameters.
(We're saving an XML file to the database).
I have ojdbc14.jar in the classpath.

when I call:
oracle.sql.CLOB tempClob = oracle.sql.CLOB.createTemporary(conn, true, oracle.sql.CLOB.DURATION_SESSION);

using a DataSource and Connection pool in WebLogic I get null pointer exceptions. If I hard code the connection with the exact same driver, url and credentials it works perfectly - even using the oracle thin connection string.

Has anyone been able to load a clob using a DataSource?
[ January 14, 2005: Message edited by: Alex Beekman ]
I agree. Here's the link:
subject: WebLogic 81 DataSource and Oracle CLOB
Similar Threads
Use two connections individually for a clob selection and updating statment.
Caused by: java.sql.SQLException: Closed Connection
Oracle Clob error on shared Sun One connection pool
dodgy oracle driver shipping with weblogic 8.1.1 and 8.1.2
unable to update CLOB data using Commons DBCP connection.