--- "Gioia, Michael" <[EMAIL PROTECTED]> wrote: > Almost every weekend the database gets bumped and > the java app that were > running needs to have tomcat restarted to reconnect > to the database thru > the connection pool. When we come in on Monday > tomcat and the database > are up and running, but the app will not connect to > the database. > > Is there a way to reestablish the connection so our > users don't have to > wait until we come in on Monday to restart tomcat? >
I haven't been following this thread in detail, so I apologize in advance if I'm repeating anyone's responses. Have you looked at: <http://jakarta.apache.org/commons/dbcp/configuration.html> In particular, the 'validataionQuery', 'testOnBorrow', 'testOnReturn', 'testWhileIdle' parameters look like they would be useful. Can you supply a redacted copy of your data source config xml? Have you set up test DB instance and Tomcat instances to replicate the problem so you don't have to wait till over the weekend for it to recur? -Bob ____________________________________________________________________________________ Food fight? Enjoy some healthy debate in the Yahoo! Answers Food & Drink Q&A. http://answers.yahoo.com/dir/?link=list&sid=396545367 --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]