Java read byte array from PostgreSQL and write to image file

Question

I need to read an image byte array from a PostgreSQL table which is done as

byte[] fileBytes = resultsSet.getBytes(1);

When I try to write it to a image file, it does not open (unsupported file type). The following is the code

FileOutputStream fos = new FileOutputStream("D:\\test.png"); 
fos.write(fileBytes);
fos.close();

`"D:\\test.png"` with doubled backslash; you wrote a tab+"est.png" — Joop Eggen, Mar 06 '19 at 11:17

score 0 · Answer 1 · answered Mar 06 '19 at 11:55

0

Try this method, worked for me:

      InputStream in = new ByteArrayInputStream(rs.getBytes(1));
      BufferedImage bImageFromConvert = ImageIO.read(in);
                    if(null == bImageFromConvert){
                        throw new Exception("Invalid image");
                    }
                    OutputStream out = new FileOutputStream("e:/images/"+"test".jpg");

        ImageIO.write(bImageFromConvert, "png", out);

answered Mar 06 '19 at 11:55

Shariq

513
4
14

I am getting `invalid image` exception even though `in ` is not null. When I am trying to call `ImageIO.read()` it returns `null`. – S_S Mar 07 '19 at 04:36
Hey, have you come across a solution? – Shariq Mar 10 '19 at 15:01
Not yet, please let me know if you have any other suggestion. – S_S Mar 12 '19 at 06:37

Java read byte array from PostgreSQL and write to image file

1 Answers1