How can I implement query timeout with Hibernate and PostgreSQL? Unfortunately, query.setTimeout(int) doesn't work, because the PostgreSQL JDBC driver ignores it.

JIRA has a brief mention of new support for Postgres.
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4765

How do I access it? PostgreSQL SQL has no "SELECT ... FOR UPDATE WAIT 1000" construct as is mentioned in the JIRA for Oracle. The official PostgreSQL method of query timeout is with the SQL statement:

SET LOCAL statement_timeout TO 1000;

But I can't find a way to execute a SQL "SET" statement with a Hibernate EntityManager native query.

This is a pretty basic issue -- does anybody have a clue?

Thanks,
--Steve

Perhaps this is the intended usage (JPA 2/JEE 6):

query.setHint("javax.persistence.lock.timeout", new Integer(timeout));

This didn't work for me with Hibernate 3.2. Is there anything that will work with a current Hibernate release?

Thanks,
--Steve

FWIW I think you could probably do this by accessing the JDBC connection directly and running an executeUpdate("SET LOCAL statement_timeout = 60000") or something along those lines.