Home » Developer & Programmer » JDeveloper, Java & XML » JDBC: Multithreaded CLOB insertion in Oracle 9i
JDBC: Multithreaded CLOB insertion in Oracle 9i [message #92671] Mon, 15 November 2004 05:07
Ali
Messages: 88
Registered: March 2000
Member
Hi,

I have a Java program that populates an Oracle 9i database with CLOBs. When I run the program with just one thread, the program works perfectly. If I try with more than one thread, I get an "Invalid empty lob operation" error for each thread

java.sql.SQLException: Invalid empty lob operation
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.sql.CLOB.getDBAccess(CLOB.java:1442)
at oracle.sql.CLOB.putChars(CLOB.java:542)
at oracle.sql.CLOB.putString(CLOB.java:627)
at ProcessorThread.addToDatabase(ProcessorThread.java:303)
at ProcessorThread.processDocument(ProcessorThread.java:233)
at ProcessorThread.run(ProcessorThread.java:73)

Each thread has its own connection (and I have tried with one persistent connection and get the same result).

Can anyone help me with this?
Thanks!
Previous Topic: JDBC/OCI driver feature
Next Topic: Get Oracle Connection from Java with IDENTIFIED EXTERNALLY
Goto Forum:
  


Current Time: Fri Mar 29 06:18:50 CDT 2024