Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inserting CLOBs into Oracle 9i with JDBC

Status
Not open for further replies.

fatcodeguy

Programmer
Feb 25, 2002
281
CA
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

Code:
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)

Can anyone help me with this?
Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top