JPA (and/or Hibernate) - How to set timeout threshold for connection and/or query?

Question

I'm trying to figure out how to configure my project such that JPA will timeout and throw an exception after a configured amount of time. There are two situations where I would like this to happen:

• When JPA is unable to even connect to the database
• When a JPA query takes longer than the timeout threshold to return a result set

I'm not sure if these two scenarios can be configured separately (a different timeout threshold for each), or if one threshold is used for both.

My project is currently set up as follows:

• Coding to the JPA 2.0 specification
• Using Hibernate 3.5.6 as the JPA implementation
• Using c3p0 connection pooling with Hibernate
• Using persistence.xml configuration file (using Hibernate-specific property values only when necessary)
• NOT using any Hibernate-specific configuration files

Answer 1

This page on the Hibernate wiki details how to configure the c3p0 connection pool, including the timeout settings.

Note that these type of details really don't have much to do with JPA or Hibernate, but are settings that you set on the DataSource / database connection (c3p0 in this case) itself.

Answer 2

JPA2 persistence property "javax.persistence.query.timeout" allows you to set the timeout for a query (assuming the underlying JDBC driver supports it).