Hi all,

I use Postgresql 7.2.3
If I want to use Postgresql OID and Hibernate I must specify in the hibernate configuration file :
Hibernate.cfg.xml :
<property name="connection.compatible">7.1</property>

If not, I have an OIDIN error.
I tested in a test class, all work fine.

Now I want it work fine with my web application.
I retrieve datasource with
<property name="connection.datasource">java:comp/env/jdbc/myWebApp</property>

datasource configuration is in tomcat server.xml.
But it appears that in this case, Hibernate doesn't set connection.compatible.

I think I must say that in servel.xml, but I don't know how.
Have you an idea, to inform the "compatible" parameters in a configuration file or in my java class (where I retrieve my Session) ?

Thank you

I found,

just put :
jdbc:postgresql://host:port/database?compatible=7.1

for database url.
In this case you can work with hibernate and postgresql OID.

J