I get a problem in writing binary data into oracle BLOB DB Column.
I follow the steps as below :
1. Insert Empty BLOB
2. Select BLOB column
3. Get OutputStream
4. Write OutputStream
5. Close all.
The procedure work totally fine.
But Out of Ten, there are 3 to 4 times fail.
and with the following error :
>>>>>>>>>>>>>
java.io.IOException: ORA-08177: ??????????
ORA-06512: ? "SYS.DBMS_LOB", line 700
ORA-06512: ? line 1
at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java:531)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutpu
tStream.java:179)
at oracle.jdbc.driver.OracleBlobOutputStream.write(OracleBlobOutputStrea
m.java:125)
at jsp_servlet._processimageupload._jspService(_processimageupload.java:
248)
....
>>>>>>>>>>>>>
Do all of you get any idea of that ??
WL Version : 5.1 (sp10)
Oracle : 8.1.7
Thanks,
007
The short answer solution is to move back to the "read committed"
transaction isolation level
and use explicit locking in your SQL only when you need exclusive access
(select ... for update). I believe
that in later WLS releases, BEA has added support for this work around in
their CMP.
I personally have only used BMP and sprinkled a few "for updates" where
needed.
Gordon
"James Bond" <lawst...@yahoo.com.hk> wrote in message
news:3cbcf178$1...@newsgroups.bea.com...
Can anyone give me some tips?
Regards
linmin
Gordon
"linmin" <lin...@bug.com.cn> wrote in message
news:3cbe...@newsgroups2.bea.com...