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
