Skip to main content



      Home
Home » Eclipse Projects » EclipseLink » Query TimeOut Hints not working in Eclipse Link 2.6(Query TimeOut Hints not working in Eclipse Link 2.6 when used with MSSQL Server DB)
Query TimeOut Hints not working in Eclipse Link 2.6 [message #1716364] Thu, 03 December 2015 04:17
Eclipse UserFriend
Query TimeOut Hints not working in Eclipse Link 2.6 when used with MSSQL Server DB

Tried with below options.
1.Adding hints to the Query Itself
Query query = em.createNamedQuery(AlertCategoryType.FIND_ACTIVE_TYPES);
query.setParameter("isInactive", Boolean.FALSE);
query.setHint(QueryHints.JDBC_TIMEOUT, "1");
2. Added Eclipse link hints to Named query
@NamedQuery(name = "AlertCategoryType.findByIsInactive", query = "SELECT a FROM AlertCategoryType a", hints={@QueryHint(name="eclipselink.jdbc.timeout", value="50")})
3. Added JPA hints to Named query
@NamedQuery(name = "AlertCategoryType.findByIsInactive", query = "SELECT a FROM AlertCategoryType a", hints={@QueryHint(name="eclipselink.jdbc.timeout", value="50")})
4. Tried adding property in persistence.xml
<property name="javax.persistence.query.timeout" value="50"/>

None of the above hints worked. Is there anything else missing out?
Please suggest any work around to work query time out when using any persistent provider with MSSQL server DB.

Thanks,
Vittal
Previous Topic:Moving Eclipselink Entities to separate jar
Next Topic:Using SessionBroker for sharded DB
Goto Forum:
  


Current Time: Fri Jun 13 19:45:09 EDT 2025

Powered by FUDForum. Page generated in 0.03443 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top