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]
