On 11/29/05, Rajiv Singla <[EMAIL PROTECTED]> wrote: > 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.
Read the thread posted on the same day "JDBC/MySQL user login goes stale". > > > > -----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] > > -- rgds Anto Paul --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]