Re: Tomcat 5.0.27 >> java.net.SocketException: Software caused connection abort: recv failed

[Tim Funk <fu...@joedog.org>]

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: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org