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

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3906358#3906358

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3906358


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to