jQuery in Action, 3rd edition
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: http://aspose.com/file-tools
subject: WebLogic 81 DataSource and Oracle CLOB
It's not a secret anymore!