The following bug has been logged online:
Bug reference: 4631
Logged by: Hauke Runge
Email address: runge@tembit.de
PostgreSQL version: 8.3
Operating system: XP professional
Description: Hibernate Restriction bigint~~bigint
Details:
Developing a project with spring, struts, hibernate 3.2 and a postgres 8.1
we were using hibernateCallback like this:
HibernateCallback callback = new HibernateCallback() {
public Object doInHibernate(Session session) throws
HibernateException, SQLException {
Criteria ct = session.createCriteria(Reminder.class);
ct.add(Restrictions.like("user", reminder.getPatient()));
ct.add(Restrictions.like("suitId", reminder.getSuitId()));
return ct.list();
}
};
this was working very well. Changing to postgreSql 8.3 we got the following
error:
ERROR: operator does not exist: bigint ~~ bigint
we changed the jdbc driver to the latest jdbc3 driver - but the error was
the same.
I think, this could be a bug.