File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
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