Reading & Updating SQL Server Image type

[Mitchell Baron]

Hello,

I am trying to create a Java method that somehow reads a SQL Server image type and returns either a blob, byte[] or whatever else would make sense so that I can display the image on a web page.

I have seen other posts about this but am still not sure how to get this to work.

Here is a small example of trying to get the image. It does not have to return a byte type, just whatever would work for displaying the image in a jsp page. I also am not sure how to prevent issues if the image column is null.

public byte[] getPhoto(int intAccountID) 
{
        byte imgPhoto;
String strSQL = "";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;

        conn = getConnection();
stmt = conn.createStatement();
strSQL = " SELECT imgPhoto " +
         " FROM Contact " +
         " WHERE intAccountID = " + intAccountID 
rs = stmt.executeQuery(strSQL);
if (rs.next())
{
         imgPhoto = rs.getBytes("imgPhoto");
}

if (rs != null) { rs.close(); }
stmt.close();
conn.close();

return imgPhoto; 
}

Any suggestions?

Many thanks!

Mitchell

[Gavin Tranter]

Instead of storing the image itself why not store a path to the image?

[Mitchell Baron]

I don't have a choice unfortunately because the images already are stored in the database otherwise I gladly wouldn't have done that. Is there an effective way to extract them with Java/JSP?

[Paul Clapham]

Have you tried writing that array of bytes to a file (with a suitable name denoting the type of image, JPG or PNG or whatever)? Does that produce a usable image file?

[Dan Walin]

On your question about how to prevent issues if the column is null, I do this type of thing:

   
 if (rs.getBytes("IMAGECOLUMN") == null) {
            //do something - set the image to some default "not found"          image, etc
        } // end if
        else {
            //do whatever you would do with the image
        } // end else
 

 

In other words, I always check if the column is null before deciding how to process it.