Upload Image to SQL Server Image type

[Mitchell Baron]

Hi all,
I'm trying to create a form that uploads an image into a SQL Server image column but can't seem to get it to work. I don't have a choice unfortunately in terms of using an image column vs. storing the image in the file system

For example, a processing page that does the following:

    
Connection conn = null;
File img = new File(request.getParameter("image"));
String strSQL = "Update Images SET img = ? WHERE ImageID = ?"; 
conn = //open db connection
PreparedStatement pstmt = conn.prepareStatement(strSQL);
pstmt.setInt(1, ImageID);
InputStream is = new FileInputStream(img); 
pstmt.setBinaryStream( 2, is, (int)(img.length()));
pstmt.executeUpdate();
is.close();
pstmt.close();
pstmt = null;

Does anyone have any suggestions what I might be able to try to get this to work?

Thank you!

Mitchell
[ August 15, 2008: Message edited by: Mitchell Baron ]