File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
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://aspose.com/file-tools
 
subject: WebLogic 81 DataSource and Oracle CLOB
 
Similar Threads
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.
Caused by: java.sql.SQLException: Closed Connection
Use two connections individually for a clob selection and updating statment.