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!
|
|
|