Hibernate postgres bytea retrieval issue

Question

I am using Hibernate 4.0 to store jpegs into postgres 9.1.4 (jdbc is postgresql-9.1-901.jdbc4.jar) bytea column(byte[] is the hibernate entity, without extra type def).

The hibernate storing process works fine because I can use Database tools to dump the bytea column and still get the jpegs. It is basically:

In the managedBean

byte [] bytes;
bytes = IOUtils.toByteArray(file.getInputstream());
entity.setImage(bytes);

At this point, the bytes look like [-1, -40, -1, -32, 0, 16, 74, 70, ...]

However, the problem starts with I am retrieving via hibernate. The data seems modified or corrupted somehow.

byte [] bytes;
bytes = entity.getImage();

At this point, the bytes become [-26, 100, 56, 102, 102, 101, 48, 48,...]

The hibernate getter is

@Column(name = "image")
public byte[] getImage() {
    return image;
}

Appreciate if anyone can assist, thanks!

Have a look at stackoverflow.com/questions/10671471/… and especially stackoverflow.com/questions/3677380/… — DrColossos
– DrColossos, Commented Jul 16, 2013 at 8:23

ianegirl · Accepted Answer · 2013-07-29 09:44:48Z

3

change bytea_output='escape' in postgresql.conf

or run this

ALTER DATABASE dbname SET bytea_output TO 'escape';

answered Jul 29, 2013 at 9:44

ianegirl

461 bronze badge

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

Collectives™ on Stack Overflow

Hibernate postgres bytea retrieval issue

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related