How to set a default query timeout with JPA and Hibernate?

configuration, hibernate, java, jpa, timeout

Solution

JPA 2 defines the javax.persistence.query.timeout hint to specify default timeout in milliseconds. Hibernate 3.5 (currently still in beta) will support this hint.

See also https://hibernate.atlassian.net/browse/HHH-4662

Problem

I am doing some big queries on my database with Hibernate and I sometimes hit timeouts. I would like to avoid setting the timeout manually on every `Query` or `Criteria`. Is there any property I can give to my Hibernate configuration that would set an acceptable default for all queries I run? If not, how can I set a default timeout value on Hibernate queries?

Original source