| BLOB - ORA-2920 [message #60551] |
Fri, 13 February 2004 09:47  |
Patrick Tahiri
Messages: 119
Registered: January 2004
|
Senior Member |
|
|
Hi,
I'm using Oracle 8i, installed the ojdbc14.jar driver file to my java lib folder. When I run a sql script to import a blob object I receive this error:
2004-02-13 06:18:58,421 [[INFO ]] ProductDataImport: CSV-file: c:contenttestsoundonweb_spmidi.csv
2004-02-13 06:19:00,524 [[INFO ]] ProductDataImport: $Revision: 1.18 $
2004-02-13 06:19:02,497 [[INFO ]] ProductDataImport: Imported 0 into product type 16
2004-02-13 06:19:02,497 [[INFO ]] ProductDataImport: 0 descriptions were inserted
2004-02-13 06:19:02,497 [[FATAL]] ProductDataImport: Execute failed. Error reading csv-file
2004-02-13 06:19:02,507 [[DEBUG]] StackTrace: Fail
java.io.IOException: ORA-22920: row containing the LOB value is not locked
at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java:717)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:279)
at oracle.jdbc.driver.OracleBlobOutputStream.close(OracleBlobOutputStream.java:238)
at no.masp.tools.imp.ProductDataImport.execute(ProductDataImport.java:187)
at no.masp.tools.imp.ProductDataImport.main(ProductDataImport.java:329)
2004-02-13 06:19:02,577 [[WARN ]] ProductDataImport: *************************************
2004-02-13 06:19:02,577 [[WARN ]] ProductDataImport: ********** ROLLBACK ***********
2004-02-13 06:19:02,577 [[WARN ]] ProductDataImport: *************************************
Can somebody help me please?
Regards,
Patrick Tahiri.
|
|
|
|
| LOB - ORA-2920 - Correction: 1. LOB; 2. Oracle 9i [message #60553 is a reply to message #60551] |
Sun, 15 February 2004 05:13  |
Patrick Tahiri
Messages: 119
Registered: January 2004
|
Senior Member |
|
|
Hi,
I'm using Oracle 9i!!!
Is the way to manipulate LOB the same in 8i as in 9i??
I done some research and I saw that I maybe need a FOR UPDATE clause... Is it right just for Oracle 9i? And ok without FOR UPDATE in 8i? Because our java call is working with ou Oracle 8i server and not with our Oracle 9i server:
java.io.IOException: ORA-22920: row containing the LOB value is not locked
Than you for your help!!
Regards,
Patrick Tahiri.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
