users@glassfish.java.net

Re: Connection pool failed overnight.

From: <glassfish_at_javadesktop.org>
Date: Sun, 07 Dec 2008 22:47:48 PST

By default MySql closes idle connections after 8 hours. Your connection pool should reclaim the connections before it times out. For this purpose you have to add the following to your connection pool settings:

idle-timeout-in-seconds="25200"

I have given 7 hours as idle-timeout. After 7 hours the app server will refresh the connections in the connection pool and there will be no more broken connections.

Hope this helps :)
[Message sent by forum member 'pvenkataraju' (pvenkataraju)]

http://forums.java.net/jive/thread.jspa?messageID=320554