Convert MySql InputStream into byte[]

Question

I am storing some images in a MySQL database using

ps.setBinaryStream(1, photo);

where photo is an InputStream.

When I read the image from database, I need to convert it to a byte[]. How can I do this?

Surely any JDBC tutorial would cover this...have you tried something yet? — Tim Biegeleisen
– Tim Biegeleisen, Commented Dec 24, 2017 at 9:41

Zerthimon · Accepted Answer · 2017-12-24 10:12:10Z

1

All you need to do is a statement and a result set. Something like this:

Statement myStatement=(Statement) myConnection.createStatement();
ResultSet myRS=myStatement.executeQuery(mySQLstring);
byte[] photo = myRS.getBytes("myphotoColumnLabel");

answered Dec 24, 2017 at 10:12

Zerthimon

4341 gold badge9 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

deadbug · Accepted Answer · 2017-12-24 10:16:25Z

1

You could try something like:

        File file=new File("E:\\image1.png");
        FileOutputStream fos=new FileOutputStream(file);
        byte b[];
        Blob blob;

        PreparedStatement ps=con.prepareStatement("select * from image_table"); 
        ResultSet rs=ps.executeQuery();

        while(rs.next()){
            blob=rs.getBlob("image");
            b=blob.getBytes(1,(int)blob.length());
            fos.write(b);
        }

The maximum length of Blob type is 64kb.Use bigger types like mediumblob or longblob.

You can also retrieve by using : inputStream imgStream = resultSet.getBinaryStream(1); as you stored the image using InputStream

edited Dec 24, 2017 at 10:16

answered Dec 24, 2017 at 9:42

deadbug

4445 silver badges20 bronze badges

1 Comment

Lothar Over a year ago

Have you actually tried this? With larger images? There is a limit on the size of byte-arrays yuo can write to a FileOutputStream at least with some JVMs out there.

Collectives™ on Stack Overflow

Convert MySql InputStream into byte[]

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related