Inserting image into the oracle database

[Anirban dutta]

How can I insert an array of bytes obtained from an image into an Oracle BLOB type column using JDBC 2.0 type 4 driver?
Thanks

[Michael Morris]

Moving this to the JDBC Forum

[Murali Nanchala]

If you have already extracted the byte array for the image, then try

xxxxxxxxStatement.setBytes(index, byteArray);

You can also look at setBlob() method of the xxxxxxxxStatement object you use.

[Anirban dutta]

I have tried out the method of the setBlob. But the problem is how to get the reference of the Blob interface. I couldn't find any code which returns the Blob's reference.
So I tried it in a different way:
I inserted a empty image into the database by empty_blob() function of SQL. Then I used the setBytes of the blob interface to set the image bytes in it. But it gave an runtime exception:
java.lang.AbstractMethodError.
What could be the problem. Please help me in solving it.

[Rene Larsen]

Try this post: https://coderanch.com/t/79988/Oracle-OAS/Inserting-BLOB
Rene

[Sandeep Ghosh]

This is how I have done

con.setAutoCommit(false);
String sql="insert into posting(postid,pic)"+
                 " values(?,empty_blob())";
 pst.setInt(1,postID);
int rowEffected=pst.executeUpdate();
stream = file.getInputStream()
 oracle.sql.BLOB blob=null;
String cmd = "SELECT pic FROM posting where postID=? FOR UPDATE";
      pst=con.prepareStatement(cmd);
      pst.setInt(1,postID);
      rs=pst.executeQuery();
      if(!rs.next())
        return ;
      blob = (oracle.sql.BLOB)rs.getObject(1);
      outstream = blob.getBinaryOutputStream();
      int size = blob.getBufferSize();
      byte[] buffer = new byte[size];
      int length = -1;
      while ((length = stream.read(buffer)) != -1)
        outstream.write(buffer);
       con.commit();
     con.setAutoCommit(true);