retriving the image from mysql display into jsp

[kaleeswaran]

ResultSet rs=st.executeQu ery("select i_sign from t_customer_phot o where n_customer_id=1 ");
while(rs.next() )
{
byte[] bytearray = new byte[4096];
int size=0;
InputStream sImage;
sImage = rs.getBinaryStr eam(1);
response.reset( );
response.setCon tentType("image/jpeg");
response.addHea der("Content-Disposition","f ilename=logo.jp g");
while((size=sIm age.read(bytear ray))!= -1 )
{
response.getOut putStream().wri te(bytearray,0, size);
}
response.flushB uffer();
sImage.close();
rs.close();
}

this is my code retriving the image....
pls help me if you find out the error....

[r035198x]

ResultSet rs=st.executeQu ery("select i_sign from t_customer_phot o where n_customer_id=1 ");
while(rs.next() )
{
byte[] bytearray = new byte[4096];
int size=0;
InputStream sImage;
sImage = rs.getBinaryStr eam(1);
response.reset( );
response.setCon tentType("image/jpeg");
response.addHea der("Content-Disposition","f ilename=logo.jp g");
while((size=sIm age.read(bytear ray))!= -1 )
{
response.getOut putStream().wri te(bytearray,0, size);
}
response.flushB uffer();
sImage.close();
rs.close();
}

this is my code retriving the image....
pls help me if you find out the error....

1.) Please use code tags when posting code
2.) Please do not flood the forum with the same question. Double posting is generally considered rude around here.
3.) What happened when you tried the code? Where there any errors/exceptions?

[kaleeswaran]

No,there is any error occurred.but image page display likes empty page.

[r035198x]

No,there is any error occurred.but image page display likes empty page.

Isn't the coloumn a Blob?
What happens if you use

image = rs.getBlob(1);
imgBytes = image.getBytes(1,(int)image.length());