Query TimeOut Hints not working in Eclipse Link 2.6 [message #1716364] |
Thu, 03 December 2015 09:17 |
Vittal Beeranagaddi 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
|
|
|
Powered by
FUDForum. Page generated in 0.02976 seconds