Hi,

I ported my application using Oracle onto Postgresql 8.4. Some queries started to fail with following exception: "org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented".

I was googling around and verified that there are a lot of issues like that but could not read out direct answer about actual source/cause of the problem. Does anybody know what's the issue about? Could it be connected with Hibernate session-factory configuration or query implementation used? Or smth. else?

Platform used:

PostgreSql 8.4
Hibernate 3.3.2.GA
Spring 2.5.6

Following PostgreSql JDBC implementation were used:
postgresql-9.0-801.jdbc4
postgresql-8.4-701.jdbc3

Full stack of failure:

Caused by: org.postgresql.util.PSQLException: Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is
not yet implemented.
at org.postgresql.Driver.notImplemented(Driver.java:753)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setQueryTimeout(AbstractJdbc2Statement.java:656)
at org.hibernate.jdbc.AbstractBatcher.setTimeout(AbstractBatcher.java:555)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:538)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1723)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835)


Wbr,
Ilhan