Home » Developer & Programmer » JDeveloper, Java & XML » java.sql.SQLException: Failed to access a CLOB column
java.sql.SQLException: Failed to access a CLOB column [message #250013] Fri, 06 July 2007 22:34 Go to next message
vinayakumar_s
Messages: 1
Registered: July 2007
Junior Member
I am this error when trying to insert Clob using jdbc in oracle,
Caused by: java.io.IOException: ORA-00376: file 1003 cannot be read at this time
ORA-01110: data file 1003: '/oravl04/oradata/LSP1/TEMP_4.dbf'

at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java(Compiled Code))
at oracle.jdbc.driver.OracleClobWriter.flushBuffer(OracleClobWriter.java(Compiled Code))
at oracle.jdbc.driver.OracleClobWriter.close(OracleClobWriter.java(Compiled Code))
... 62 more
Re: java.sql.SQLException: Failed to access a CLOB column [message #250021 is a reply to message #250013] Sat, 07 July 2007 01:17 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
The docs say on ORA-00376

ORA-00376 file string cannot be read at this time

Cause: An attempt was made to read from a file that is not readable. Most likely the file is offline.

Action: Check the state of the file. Bring it online.


Looks like your datafile TEMP_4.dbf is not online. Not a java issue.
Previous Topic: Retrieve Element value
Next Topic: Need ADF Swings Deployment Documentation In Oracle Application Server
Goto Forum:
  


Current Time: Thu Mar 28 12:51:04 CDT 2024