On 6/6/07, Jacob Rhoden <[EMAIL PROTECTED]> wrote:
Hi,

Under tomcat 5.5, I would prevent the database connections from timing
out by having a Cron job that accesses the website every 10 minute.
(Because I couldn't work out a better way).

How are you connecting to the database? If you are not using
connection pooling, then you're missing out on performance also, it is
highly configurable
http://jakarta.apache.org/commons/dbcp/configuration.html

If you get an exception, you could try re-connecting in the catch
statement of that exception.

This no longer works under
tomcat 6. Are there any better ways than I am not aware of.? I don't
think increasing the timeout length in Mysql is a much better solution.

Best Regards,
Jacob


Rashmi

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to