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