Eclipse Community Forums: EclipseLink » Query TimeOut Hints not working in Eclipse Link 2.6

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)

Show: Today's Messages :: Show Polls :: Message Navigator

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

Report message to a moderator

Previous Topic:	Moving Eclipselink Entities to separate jar
Next Topic:	Using SessionBroker for sharded DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 08 07:43:03 GMT 2021

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter