-
1. Re: oracle query timeout
adrian.brock Nov 9, 2005 8:26 AM (in response to asmodean)Only if your jdbc driver supports it as a connection property.
AFAIK, Oracle does not. -
2. Re: oracle query timeout
asmodean Nov 9, 2005 8:45 AM (in response to asmodean)So the alternative is upgrading JBoss 4.0.2 to 4.0.3...
Thanks for the quick response!
Massimo -
3. Re: oracle query timeout
asmodean Nov 9, 2005 10:10 AM (in response to asmodean)I would avoiding upgrade to JBoss 4.0.3; so is it possible for Oracle to set query timeout via EJB?
Thanks! -
4. Re: oracle query timeout
adrian.brock Nov 9, 2005 10:45 AM (in response to asmodean)http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossHelp
* The forums are not here so you can avoid reading the documentation and release notes
* Questions about EJB or jdbc persistence in general belong in the persistence forum.
Here is an overview of the history for somebody who finds this thread in future:
JDBC has a feature that lets you limit how long a query will run.
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#setQueryTimeout(int)
In JBoss-3.2.x a feature was added that lets you automatically set this to
the time remaining in the JTA transaction (assuming you have one).<set-tx-query-timeout>
However, the person that added this, did not apply it to the 4.0.x codebase.
This was corrected in 4.0.3
http://jira.jboss.com/jira/browse/JBAS-2027
with other possible timeout configurations also added.
So unless:
1) Your database has an internal configuration for this (e.g. a resource constraint)
2) Your jdbc driver has a connection property to set it for the connection as a whole
3) Your jdbc framework (CMP/EJB3/Hibernate/other) supports it (e.g. org.hibernate.timeout)
4) You set it yourself using the jdbc api
It isn't going to work on 4.0.0 through 4.0.2 -
5. Re: oracle query timeout
asmodean Nov 10, 2005 3:44 AM (in response to asmodean)Adrian,
I thank you very much for the quick response!
I'm sorry for posting in bad forum;in future i'll try to put more attention to posting.
Greetings!