how to save files into oracle database using java as a object.

[Mannu Pal]

Hi ,
i have a requirement in which i have to save some files into a table. and these files may b in any format like (Pdf, csv, doc etc). i have to do this using java coding.

can any one guide me to do this.

Thanks ,

Mannu Pal.

[raj malhotra]

you can use blob type to save file of any format as it stores the binary format.

[Campbell Ritchie]

I am sure "b" is a simple spelling error, but beware: using pseudo-words can make the posts very difficult for some people to read. Please see this FAQ.

[Mannu Pal]

Hi raj malhotra ,

i am using blob type. and i am able to save data into oracle database(as object). but at the time of retrieving i am not getting real one.
at the time of insert i am checking the byte[] and at the time or retrieve its giving different byte[].

can you guide how to do this.
if required i will share code with you.

Thanks ,
Mannu Pal.

[raj malhotra]

Try to save and retrieve this way:

// CREATE TABLE t1 (c1 INT PRIMARY KEY NOT NULL, c2 BLOB(5M)); 
 
PreparedStatement pstmt = conn.prepareStatement ("INSERT INTO t1 VALUES (?,?)");
pstmt.setInt (1, 100);
File fBlob = new File ( "image1.gif" );
FileInputStream is = new FileInputStream ( fBlob );
pstmt.setBinaryStream (2, is, (int) fBlob.length() );
pstmt.execute ();
...
 
Retrieving a BLOB
 
// CREATE TABLE t1 (c1 INT PRIMARY KEY NOT NULL, c2 BLOB(5M)); 
 
Statement stmt = conn.createStatement (); 
ResultSet rs= stmt.executeQuery("SELECT * FROM t1"); 
while(rs.next()) { 
int val1 = rs.getInt(1); 
InputStream val2 = rs.getBinaryStream(2); 
... 
} rs.close(); 

[tillu Sharma]

thanks save file in database but how to download save in database file...what is the exact procedure....