interactive/wait_timeout = 120Seconds max_connection = 1500
still we are getting errors. -- Regards, Dhaval On Fri, May 6, 2011 at 4:05 PM, Nigel Wood <nw...@plus.net> wrote: > On Fri, 2011-05-06 at 11:12 +0100, Dhaval Jaiswal wrote: > > Caused by: java.net.SocketException: Socket closed > > I'd suggest you look at server side timeout and maximum connection > settings in > http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html I'd > suspect wait_timeout is the setting you're interested in. You might also > want to check the maximum TCP session/idle timeouts on firewalls, > routers and other network devices between the failing system and its > MySQL server. > > Hope that helps, > Nigel > > -- Regards, Dhaval Jaiswal