Hi, I was already using 'autoReconnect=true' option. But after going through MySql website, I found that it has been deprecated and in order to use 'autoReconnect' option you now need to use 'enableDeprecatedAutoreconnect=true'.
I am trying this option for now, if it doesn't work then maybe I'll have to find another solution. Rajiv -----Original Message----- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 5:24 PM To: Tomcat Users List Subject: Re: Tomcat 5.0.27 >> java.net.SocketException: Software caused connection abort: recv failed Not a tomcat issue. Its a mysql driver issue. IIRC - there is an autoreconnect option for the mysql driver. -Tim Rajiv Singla wrote: >>Hi, >> >>I am working on a web application which uses Tomcat-5.0.27 as Application >>server and MySql 4.1 as DB server. >>The application uses Struts 1.1 and Hibernate 3.0 frameworks. >> >>I am facing a problem with the application. If the servers are kept running >>idle for a long time(7-8 hours or overnight) and then someone tries to login, >>the application does not allow the user to login and throws exceptions. >>When I restart the MySql server, the problem still remains but if I restart >>the Tomcat server, it works fine. >> >>Could someone tell me what is the problem with the servers and how it could >>be rectified? >> >>Here is the full stack trace of errors I get : >> >>STACKTRACE: >> >>java.net.SocketException: Software caused connection abort: recv failed >>at java.net.SocketInputStream.socketRead0(Native Method) >>at java.net.SocketInputStream.read(SocketInputStream.java:129) >>at java.io.BufferedInputStream.fill(BufferedInputStream.java:183) >>at java.io.BufferedInputStream.read1(BufferedInputStream.java:222) >>at java.io.BufferedInputStream.read(BufferedInputStream.java:277) >>at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1316) >>at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1463) >>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1854) >>at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109) >>at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203) >>at com.mysql.jdbc.Connection.execSQL(Connection.java:2090) >>at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1496) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]