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]

Reply via email to