aspose file tools
The moose likes JDBC and the fly likes WebLogic 81 DataSource and Oracle CLOB Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "WebLogic 81 DataSource and Oracle CLOB" Watch "WebLogic 81 DataSource and Oracle CLOB" New topic
Author

WebLogic 81 DataSource and Oracle CLOB

Alex Beekman
Greenhorn

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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: WebLogic 81 DataSource and Oracle CLOB
 
Similar Threads
dodgy oracle driver shipping with weblogic 8.1.1 and 8.1.2
Use two connections individually for a clob selection and updating statment.
unable to update CLOB data using Commons DBCP connection.
Oracle Clob error on shared Sun One connection pool
Caused by: java.sql.SQLException: Closed Connection