open/Read file from oracle bfile

[priya kakkar]

I had a project to insert data into Bfile column in oracle DB and read it back in JAVA:

I did as below but getting error @ line where i am trying to open file to read:

*****************************************************************************************

// select the bfile locator
cmd = "SELECT *  FROM my_bfile_table WHERE x = 'two'";
rset = stmt.executeQuery (cmd);
 
if (rset.next ())
    BFILE bfile = ((OracleResultSet)rset).getBFILE (2);
 
// for these methods, you do not have to open the bfile
println("getDirAlias() = " + bfile.getDirAlias());
println("getName() = " + bfile.getName());
println("fileExists() = " + bfile.fileExists());
println("isFileOpen() = " + bfile.isFileOpen());
 
// now open the bfile to get the data
bfile.openFile(); //GETTING RUNTIME ERROR HERE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 
// get the BFILE data as a binary stream
InputStream in = bfile.getBinaryStream();
int length ;
 
// read the bfile data in 6-byte chunks
byte[] buf = new byte[6];
 
while ((length = in.read(buf)) != -1)
{
    // append and display the bfile data in 6-byte chunks
   StringBuffer sb = new StringBuffer(length);
   for (int i=0; i<length; i++)
sb.append( (char)buf[i] );
System.out.println(sb.toString());
}
 
// we are done working with the input stream. Close it.  
in.close();
 
// we are done working with the BFILE. Close it. 
bfile.closeFile();
 

*******************************************************

Error message states:
java.sql.SQLException: ORA-22285: non-existent directory or file for FILEOPEN operation
But file exist in the location mentioned
Please suggest if i have to give some some folder setting at directory level.
Folder is visible to all users to read and write>

[Liutauras Vilda]

Hi priya kakkar,

Please use code tags when you post actual code. I have added them for you.
See how better your code looks like?

You could find some useful information how to UseCodeTags (<- link).

[Campbell Ritchie]

What happens when you execute that query at the command line? I presume that works; it looks simple enough.

Which line does that Exception occur on? Please show us the exact paths to the class you are executing that code in, and the location of the Oracle program, and the instruction you are using to open the connection.

[priya kakkar]

Getting error at :
// now open the bfile to get the data
bfile.openFile(); //GETTING RUNTIME ERROR HERE!!!

running code from eclipse @ C:\Data\Softwares\Code backup\PDAutomation8.2\src\com\ing\qa\dbtools

[Campbell Ritchie]

And what is the error? Please post the stack trace and type of Exception. If it is an SQLException please look in your handbook to find what the error code means.

[Dave Tolls]

What output do you get from:

println("fileExists() = " + bfile.fileExists());
println("isFileOpen() = " + bfile.isFileOpen());

?

Also does Oracle have permission to actually access that directory and file?