Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    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 09:17
Vittal Beeranagaddi is currently offline Vittal BeeranagaddiFriend
Messages: 1
Registered: December 2015
Junior Member
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: Mon Mar 08 07:43:03 GMT 2021

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

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

Back to the top