Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLException: ORA-08177: can't serialize access for this transaction

279686May 23 2002
Hiya, If anyone has any suggestions on the following, i would be grateful...

The exception is thrown by the flushing of the OutputStream in the following few lines:

java.io.OutputStream os = ((weblogic.jdbc20.common.OracleClob) myClob).getAsciiOutputStream(); os.flush();

The exception given is: java.io.IOException: Error while doing writeLobByteValue: java.sql.SQLException: ORA-08177: can't serialize access for this transaction at weblogic.db.oci.OciOutputStream.flush(OciOutputStream.java:152)

... plus a whole pile of internal stuff

This method is called from the ejbStore() method of an EJB, and it only fails the first time that ejbStore() is called, and then after that runs smoothly.

Any suggestions appreciated, Cheers, Karen.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2002
Added on May 23 2002
2 comments
502 views