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

Question

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?

Answer 1

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