mysql, blobs, images

[Wendy Gibbons]

i have one program that inserts an image onto a mysql database

 
i++;
BufferedImage image = ImageIO.read(file);
int height = image.getHeight();
int width = image.getWidth();
InputStream stream = new FileInputStream(file);
prepareStatement.setString(1, name);
prepareStatement.setInt(2, height);
prepareStatement.setInt(3, width);
prepareStatement.setBlob(4, stream );
prepareStatement.setString(5, file.getName());
prepareStatement.setInt(6, i);
boolean b = prepareStatement.execute();
int count = prepareStatement.getUpdateCount();
loaded+=count;   

and then one that trys to read it and display it

PreparedStatement stmt = connection.prepareStatement("select directory,height,width,photo,photo_name,photo_id_for_dir from photos limit 1");
stmt.execute();
ResultSet resultSet = stmt.getResultSet();
resultSet.first();
Blob blob = resultSet.getBlob(4);
int hieght = resultSet.getInt(2);
int width = resultSet.getInt(3);
bytes = blob.getBytes(1, ALLBITS);
ImageIcon image = new ImageIcon(bytes);
setSize(new Dimension(width+100, hieght+100));
JLabel label = new JLabel(image);
getContentPane().add(label);
setVisible(true); 

the exception i am getting is:

 sun.awt.image.ImageFormatException: JPEG datastream contains no image
	at sun.awt.image.JPEGImageDecoder.readImage(Native Method)
	at sun.awt.image.JPEGImageDecoder.produceImage(Unknown Source)
	at sun.awt.image.InputStreamImageSource.doFetch(Unknown Source)
	at sun.awt.image.ImageFetcher.fetchloop(Unknown Source)
	at sun.awt.image.ImageFetcher.run(Unknown Source)   

so how do i tell if it is the insert or select that is failing?

[Ernest Friedman-Hill]

What is "ALLBITS"?

bytes = blob.getBytes(1, ALLBITS);

Shouldn't this be

bytes = blob.getBytes(1, blob.length());

[Wendy Gibbons]

i saw allbits, and it made sense so tried it, your version works a lot better.
Thanks.
but is there a way to get the blob out just using mysql as i am sure i will have further problems?

[Ernest Friedman-Hill]

Hi Wendy,

Hmm, what do you mean exactly, "Just using mysql?" I don't understand.

[Wendy Gibbons]

sorry nothing really, now i have the test read program working that is fine, thank you very much