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
– Wivani, Commented Jul 12, 2011 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
– androidGuy, Commented Jul 12, 2011 at 10:45

Bozho · Accepted Answer · 2011-07-12 10:53:29Z

8

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

answered Jul 12, 2011 at 10:53

Bozho

599k147 gold badges1.1k silver badges1.2k bronze badges

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

2 Comments

Bozho Over a year ago

well, you need the connection object, obviously :)

Majid Azimi Over a year ago

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.

sarfaraz khan · Accepted Answer · 2016-04-25 10:54:11Z

3

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

answered Apr 25, 2016 at 10:54

sarfaraz khan

311 bronze badge

Comments

Sergei Glotov · Accepted Answer · 2012-07-03 14:00:18Z

1

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

Blob blob = Hibernate.createBlob(bytes);

edited Jul 3, 2012 at 14:00

Sergei Glotov

20.4k11 gold badges87 silver badges100 bronze badges

answered Jul 3, 2012 at 13:36

Sirish

9373 gold badges15 silver badges25 bronze badges

1 Comment

Adri w Ukraine Over a year ago

this is deprecated. See docs.jboss.org/hibernate/orm/3.5/api/org/hibernate/…

Collectives™ on Stack Overflow

Easiest way to convert byte array into Blob in java

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related