db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andras Balogh <and...@reea.net>
Subject Re: Problem with DB connection
Date Tue, 11 Jul 2006 13:32:24 GMT
Hello,

Check here:
 http://dev.mysql.com/doc/refman/4.1/en/cj-configuration-properties.html
You should add the autoReconnect or autoReconnectForPools in the 
connection URL
of mysql.

Best regards,
Andras.


Rafal Markut wrote:

> Hello,
>
> I use Turbine 2.3.2 and Torque 3.1.1, Tomcat and MySQL 4.1.7.
>
> Very often I got the exception:
> Caused by: org.apache.torque.TorqueException: java.sql.SQLException: 
> Lost connection to server during query
> or
> java.net.SocketException: Software caused connection abort: recv failed.
>
> When I make first DB operation (in this case takes user-data from the 
> DB during loggin) then it comes one of these exceptions.
> It happens always in the morning - when application was not used ca. 
> 12-15h. When the application is used then everything works perfectly. 
> But ... when it isn't used some time (like 5-10h) and then somebody 
> make first DB operation  ... then this exception appears.
> When after that I restart the tomcat then everything works fine.
>
> MySQL must be OK because other software is using it and there are no 
> problems.
>
> I made 2 different applications, both of them are on differend servers 
> and both have this same problem.
> I don't think that it's a bug in the turbine or torque because I 
> couldn't find any info about it.
> Maybe my configuration is wrong ?
>
> What is strange ... when I put jar with MySQL driver into /WEB-INF/lib 
> then I got exception that it cannot find a driver. I had to place it 
> under: tomcat/common/endorsed.
>
> I tried with following MySQL drivers: mm.mysql-2.0.4.jar and 
> mysql-connector-java-3.1.13.zip.
>
> I'd very greateful for any help. I really don't know what can I do 
> with it.
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message