Retrieving an image from SQL Server database

[Nidhi Singhal]

Hi,

I am storing an image in the SQL Server database, but facing a problem in retrieving it back.
I am using PreparedStatement and getBinaryStream() method to retrieve an image as InputStream. But after that, I am unable to convert it from the InputStream to a byte array.
If anybody know the solution, please letme know....

Thanks,
Nidhi

[Adeel Ansari]

It is not a servlet specific question, though.
Could you please show up your code?

[Naveen Mishra]

Hi Nidhi,
go through the following link and ur problem is no more...
http://swforum.sun.com/jive/thread.jspa?threadID=46410&tstart=0

[Chidanand Chauhan]

I think the below code would fullfill your problem.


//code for the conversion of the image into the bytes form

import java.io.*;
import javax.imageio.*;
import javax.imageio.stream.*;
 
class mytest
{
   public static void main(String[] s)
   {
     try
     {
        FileInputStream f=new FileInputStream("Chauhan.gif");
           ImageInputStream  ia=null;
   ia=ImageIO.createImageInputStream(f);
   ByteArrayOutputStream bout=new ByteArrayOutputStream();
   for(int ret=ia.read();ret>=0;ret=ia.read())
          {
           bout.write(ret);
          }        
         byte[] res=bout.toByteArray();
        for(int q=0;q<res.length;q++)
        {
             System.out.print((char)res[q]);
        }
        }
        catch(Exception e)
       {
      }
  }
 
}

Thanks
Chidanand Chauhan



[EDIT - Code tags added by Dave]
[ November 28, 2005: Message edited by: David O'Meara ]

[David O'Meara]

Moving this to the JDBC forum.

Dave

[payal agrawal]

Look at the URL below:

How to store/retrieve image to/from SQLServer
http://www.java-tips.org/content/view/203/29/

[Nidhi Singhal]

Thanks to all of you for the help.

Chidanand, I have used your code and it's working perfectly. Thanks...

Earlier I was trying to write the bytes to a file...but it was too slow..
but on using imageio as in your code.... it's working quite fast...
thanks...

Nidhi