Byte array to blob in java

Question

I have a database in mysql. In this I have a table which is storing image in blob format. From my Java program I want to insert a new image into the table. But When I tried to convert a byte[] to blob using

java.sql.Blob blob=null;
blob.setBytes(1, myByte );

I am getting null pointer exception.

Again tried by converting:

 Blob blob = Hibernate.createBlob(bytes);

But here also got exception wrong format.

try with the connection Blob blob = connection.createBlob(); — AurA
– AurA, Commented Aug 11, 2014 at 6:13
I tried but I got exception java.lang.AbstractMethodError: com.mysql.jdbc.Connection.createBlob()Ljava/sql/Blob; — DRD
– DRD, Commented Aug 11, 2014 at 7:46

Jens · Accepted Answer · 2014-08-11 06:12:06Z

9

if you use this code:

java.sql.Blob blob=null;
blob.setBytes(1, myByte );

blob is null. You have to create a new Blob Object like:

Blob blob = new SerialBlob(myByte );

and then you can store it.

answered Aug 11, 2014 at 6:12

Jens

69.6k15 gold badges107 silver badges133 bronze badges

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

10 Comments

DRD Over a year ago

I tried the same thing as you specified ..But I am getting this Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Image``='javax.sql.rowset.serial.SerialBlob@1229be35' where `PeopleId = 'xxx' at line 1

Jens Over a year ago

@DRD Can you please show the code where you use the blob?

DRD Over a year ago

String imageVal = hexToString(peopleData.getImage()); byte[] image =(imageVal).getBytes(); java.sql.Blob blob=null; try { blob = new SerialBlob(image); //blob.setBytes(1, image ); } catch (SQLException e1) { } String query = "UPDATE peopleimage SET Image='" +blob + "' where `PeopleId = '"+ peopleData.getId() + "'"; try { stmt = con.createStatement(); stmt.execute(query); } catch (SQLException e) { }

Jens Over a year ago

@DRD use prepared statement. Here is an example how you can do this.

DRD Over a year ago

Again error com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Image``='javax.sql.rowset.serial.SerialBlob@418ae96e' where `PeopleId = '8a8887d' at line 1

|

Collectives™ on Stack Overflow

Byte array to blob in java

1 Answer 1

10 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Related