users@glassfish.java.net

specify query timeout when using toplink essential query hint

From: <glassfish_at_javadesktop.org>
Date: Fri, 19 Mar 2010 05:57:45 PDT

Hi,
For glassfish v2, I have searched through the web and I cannot find anyway to specify query timeout when using TopLink essential query hint. We have another option to migrate to EclipseLink but that is not feasible.

have tried the solution in
http://forums.oracle.com/forums/thread.jspa?threadID=974732&tstart=-1
but it seems the DatabaseQuery which one could set a timeout value is actually for Toplink, not TopLink essential.

Do we have some other way to instruct the JDBC driver for this timeout value other than the query hint? I need to do it on query-basis and not system-basis (which is just to change the value of DISTRIBUTED_LOCK_TIMEOUT)
[Message sent by forum member 'yhzs8']

http://forums.java.net/jive/thread.jspa?messageID=392744