Chris, Thanks very much for the suggestion.
I'm not using connection pooling at this stage. I have deployed my web service scoped as an Application. It only uses one connection, and the classes maintain some medium sized data structures which I do not want to have to re-create each time the service is consumed. I'll investigate the pooling, as an auto-reconnect feature will be necessary in some form or another, and if DBCP can do it then that would be great, even if I maintain only one connection I guess... cheers Dave -----Original Message----- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Tuesday, 12 December 2006 10:33 AM To: Tomcat Users List Subject: Re: tomcat pauses then crashes after a period of time -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 David, David Wood wrote: > Ok, I have found the problem. A firewall between my tomcat server and a > MySQL server was closing the database connection. [snip] > The execution continued and an exception was thrown, > where in the catch{} section I was then calling System.exit(), which I > thought would shut down the web service only, but it is actually shutting > down the whole JVM, causing tomcat to stop too. Heh, well /there's/ yer problem. Firewalls are known for terminating "idle" TCP/IP connections after a certain period of time, which is unfortunate, as many deployments put the database behind the firewall and the app servers out front. Are you using any kind of database connection pooling? If so, perhaps there is an auto-reconnect feature available for that component. For instance, Jakarta Commons DBCP includes such a feature. Once you are using DBCP, your code doesn't have to know how to handle unexpected disconnects like that, since the connection pool handles the automatic reconnection for you. Hope that helps, - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFffjT9CaO5/Lv0PARAl6EAJ4haR5ZfDodrGTK3oF3gdkotulG3ACgha8t wozRXyBuzTQDxPakjMFeqgI= =O8Fy -----END PGP SIGNATURE----- --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]