Easiest way to convert byte array into Blob in java

Question

What is the easiest way to convert byte array into Blob data type in MYSQL with java programming language?

Have you tried anything yourself? Googling "java convert byte[] to sql.blob" gives a lot of hits .. — Wivani, Jul 12 '11 at 10:39
well i have been googling for some time now,thats y i finally thought of posting it here.I did convert byte array to a serialblob bt had a problem converting it back to a bytearray since my table column was of type blob.I am here to get a proper way of converting a byte array into a blob,thanks:) — androidGuy, Jul 12 '11 at 10:45

score 8 · Accepted Answer · answered Jul 12 '11 at 10:53

8

Blob blob = connection.createBlob();
blob.setBytes(1, bytes);

answered Jul 12 '11 at 10:53

Bozho

2

well, you need the connection object, obviously :) – Bozho Feb 21 '12 at 09:30
`setBytes()` returns number of bytes written. Should we write it inside loop for partial write? or single line of code will suffice? I have a 50KB `byte[]` all in memory which I want to save. – Majid Azimi Sep 16 '12 at 11:16

score 2 · Answer 2 · answered Apr 25 '16 at 10:54

2

Blob fileBlob = new javax.sql.rowset.serial.SerialBlob(byteArray);

answered Apr 25 '16 at 10:54

sarfaraz khan

score 1 · Answer 3 · edited Jul 03 '12 at 14:00

1

You may try this one, if you are using hibernate.. Possibly the easiest way! :)

Blob blob = Hibernate.createBlob(bytes);

edited Jul 03 '12 at 14:00

Sergey Glotov

answered Jul 03 '12 at 13:36

Sirish

4

this is deprecated. See http://docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/Hibernate.html#createBlob(java.io.InputStream) – Adrien Be Oct 03 '12 at 12:59

3 Answers3