blob.putBytes(long,byte[]) and BLOBs

[reddy palwai]

hello,
I have a question...
I am using BLOBs to insert image file into the database.
After inserting an Empty_blob() into the database. I want to use blob.putBytes(long,byte[]) method to load the bytes into the blob.
I am getting the parameter from the html form.
AS request.getParameter("blob") gets the type String. I need to convert it into byte[]. Is it possible in java?? please help.
Can anyone please send me some sample code for inserting and retrieving BLOBs from the database. I dont have much experience in java servlets.
Thanks,
Reddy

[Thomas Paul]

This forum is for posting questions about javaRanch...not Java! I am moving this to the servlets forum.

[sonny kher]

let me know if you don't understand any of this, its pretty straight forward really

import java.sql.*;
import oracle.sql.*;
import oracle.jdbc.driver.*;
import oracle.jdbc.OracleResultSet;

   query = "Insert into table1 Repository(digitalobject) values(empty_blob())";
        import java.io.*;

db.executeQuery(query);
ResultSet rs =  db.executeQuery(query);
       
                if(rs.next()){
                        blob = ((OracleResultSet)rs).getBLOB(3);
                } 
               
OutputStream out = blob.getBinaryOutputStream();
out.write(bob);
out.close();
db.close();

[reddy palwai]

Thanks Sony for your Response. I have another question now about file uploading that I have just posted.