[jboss-user] validationQuery and jboss

Hi, Does 'validationQuery' work w/ jboss? One of our customers has an intermittent 'connection reset by peer' error when connecting from the app server to the database. I search a bit and found some posts/articles suggesting using a 'validationQuery' property on the data source to force the driver to execute-a-query-and-thus-reset-the-connection. The documentation, however, was less than-complete. Furthermore, I'm not sure I can specify this information using the jboss datasource configuration file (-ds.xml ). I've grepped the jboss-3.2.6 source and see no reference whatsoever to 'validationquery' --so hence my query to the list. We're running Jboss-3-2.6 links: http://tomcat.apache.org/tomcat-5.0-doc/jndi-resources-howto.html *validationQuery* - SQL query that can be used by the pool to validate connections before they are returned to the application. If specified, this query MUST be an SQL SELECT statement that returns at least one row. http://confluence.atlassian.com/display/JIRA/Surviving+Connection+Closure..., the Commons DBCP (Database Connection Pool) which is used by the Tomcat application server (and hence JIRA Standalone) can validate connections (by running a simple SQL query) before issueing them, and if a broken connection is detected, a new one is created to replace it. To do this you will need to set the "validationQuery" option on the database connection pool. thanks bill m