Users in Production on PostgreSQL and Hibernate

[Sathwik B P <sa...@gmail.com>]

Hi Community,

With the upcoming release of ODE 1.3.7, it has been found that there are
differences in the scripts published on the ODE website for PostgreSQL and
handling of BLOB columns by Hibernate.

Hibernate 3.3.2 by default maps BLOB as OID column types and VARBINARY as
BYTEA column types.

Currently, all the BLOB (byte arrays) are defined as BYTEA data type in the
scripts published on the ODE website. This is in conflict with how
Hibernate handles BLOB.

So, we will override this behaviour in Hibernate by using a custom dialect
to mark BLOB as BYTEA instead of default OID.

Kindly report your concerns or suggestions.

reference: http://in.relation.to/2010/05/11/postgre-sql-and-blo-bs/

regards,
sathwik