How to set the timeout period on a JPA EntityManager query

by

Yes, there javax.persistence.query.timeout. According JPA 2.0 specification support for this query hint is optional:

Portable applications should not rely on this hint. Depending on the
persistence provider and database in use, the hint may or may not be
observed.

Default value (in milliseconds) can be set to persistence.xml for all queries:

<property name="javax.persistence.query.timeout" value="1000"/>

Same property can be also given when creating EntityManagerFactory via Persistence.createEntityManagerFactory.

It can also be overridden/set per query:

query.setHint("javax.persistence.query.timeout", 2000);

Same functionality can be obtained via attribute hints in NamedQuery.

More Related Contents:

  1. How to set a default query timeout with JPA and Hibernate?
  2. having an exception when saving oracle type object in some entity
  3. How can I make a JPA OneToOne relation lazy
  4. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  5. How to map calculated properties with JPA and Hibernate
  6. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  7. Can someone explain mappedBy in JPA and Hibernate?
  8. When and why JPA entities should implement the Serializable interface?
  9. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  10. When to use EntityManager.find() vs EntityManager.getReference() with JPA
  11. How to generate the JPA entity Metamodel?
  12. Hibernate: Automatically creating/updating the db tables based on entity classes
  13. How to use @Id with String Type in JPA / Hibernate?
  14. Getting Database connection in pure JPA setup
  15. Hibernate and no PK
  16. Hibernate SessionFactory vs. JPA EntityManagerFactory
  17. annotation to filter results of a @OneToMany association
  18. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  19. Deploying application using Hibernate JPA 2.1 to IBM WebSphere gives NullPointerException
  20. Is it possible to dynamically define column names in Hibernate / JPA?
  21. JPA Multiple Embedded fields
  22. Hibernate: “Field ‘id’ doesn’t have a default value”
  23. Create the perfect JPA entity [closed]
  24. Delete Not Working with JpaRepository
  25. PersistenceUnit vs PersistenceContext
  26. Force refresh of collection JPA entityManager
  27. Hibernate native query – char(3) column
  28. JPA: How do I specify the table name corresponding to a class at runtime?
  29. How to force Hibernate to return dates as java.util.Date instead of Timestamp?
  30. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues

Leave a Comment