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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
