hibernate reading byte array wrong

Asked Jan 09 '18 at 21:57

Active Jan 09 '18 at 22:28

Viewed 447 times

I am trying to read byte array from mysql which is stored as BLOB into the db. I created a rest api which is based on Spring Boot and Hibernate. Everything works fine but byte[] array seems a little bit different than stored into db.

This is the byte array in database : 11,7,5
This is what hibernate gets from db :[49, 49, 44, 55, 44, 53]
This is what I see in my browser : data: "MTEsNyw1"

Here is my hibernate code

class MyData{
    ...
    @Column(name="data",columnDefinition="BLOB")//this is what I tried but did not work!
    private byte[] data;
}

And with that, I want to return data array which is 11,7,5 from Jackson Mapper. Could you help me with annotations or something useful with this?

asked Jan 09 '18 at 21:57

Abdullah Tellioglu

1,434
1
10
26

Can you try to add the annotation: `@Lob(type = LobType.BLOB)` – clinomaniac Jan 09 '18 at 22:51
type does not resolved, I only can add @Lob interface, can not add any property – Abdullah Tellioglu Jan 09 '18 at 22:54
Try to just run with @Lob and see if it helps. – clinomaniac Jan 09 '18 at 22:56
It does not help – Abdullah Tellioglu Jan 09 '18 at 22:57
Another thing you can try... @Basic annotation as used in this answer: https://stackoverflow.com/a/38632722/3179169 – clinomaniac Jan 09 '18 at 22:59
I did try and result is still the same. data in store is "5", and written as [53] to console. data is 11,7,5 in database, and written as [49, 49, 44, 55, 44, 53] to console – Abdullah Tellioglu Jan 09 '18 at 23:01
Those are ascii values for the numbers. Can you check the contents of the byte[] and then see how you read from it? – clinomaniac Jan 09 '18 at 23:51
In your Controller, try `response.setHeader` and/or `response.setContentType` in your GET method's response. – Luay Abdulraheem Jan 10 '18 at 00:50

hibernate reading byte array wrong

0 Answers0