vegaasen/hibernate-jpa-postgres-issues.md

## hibernate-jpa-postgres-issues.md

      
    Raw
  

              hibernate-jpa-postgres-issues.md
            
          
    The problem

It seems like mapping a LOB-type from Hibernate is not as easy as you'd think. If you're like me, you'll toss something like the following annotation to
a POJO and hoping that all is fine:
@Lob
@Column(name = "picture")
private byte[] picture;

However, lo and behold - things is not as expected. Hibernate throws all kinds of fancy exceptions - such as:
org.postgresql.util.PSQLException: Bad value for type long : x

So, you'll think that something is wrong with the mapping - and thats right! It seems like Hibernate maps LOBs to OIDs unless others specified. Duh..
The solution

The solution is then to add a Hibernate-specific annotation that specifies the type, such as:
@Lob
@Type(type = "org.hibernate.type.BinaryType")
@Column(name = "picture")
private byte[] picture;

This fixes the issue and the bytestream is being feeded to the POJO attribute. Jeay!
Disclaimer

As far as I can understand, this only happens to the following databases:

OracleSQL
PostgresSQL

We're using the following properties:
Properties props = new Properties();
props.put(Environment.DIALECT, org.hibernate.dialect.PostgreSQL94Dialect.class.getName());
props.put(Environment.FORMAT_SQL, "true");
props.put(Environment.USE_STREAMS_FOR_BINARY, "false");

Enjoy! :-)