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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Retrieve Element value
Next Topic: Need ADF Swings Deployment Documentation In Oracle Application Server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 22:22:20 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.