MYSQL 5.0 Connection Time Out

[cotasson]

Hi all,

I am using MySQL 5.0, and developing an internal WebApplication (Java
based, running on Tomcat).
Every morning, I have the following error
[http://sagamore.free.fr/draft/stackTrace._CSLDBtxt].

As far as I know, this is due to some kind of connection timeout that
did not happen before version 5 of MySQL.

Nevertheless, I did not find a workaround to this myself so far...

You find my Connector (Java class handling the JDBC connection) at
http://sagamore.free.fr/draft/connector_CSLDB.txt

Any idea about what I am supposed to do ?
Any hint, tip much appreciated.

Cheers !
--
http://blog.cotasson.info/

[Bill Karwin]

co******@gmail.com wrote:

As far as I know, this is due to some kind of connection timeout that
did not happen before version 5 of MySQL.

I've run into this before, and the best solution I found after a lot of
google searches is that your Java app should catch exceptions and
reconnect to MySQL as needed. That never seemed very satisfying. :-(

Does the following web page help? It says you can specify a maxWait
parameter with a value of -1 to disable timeouts. I have not used this,
I just found the page now.

http://www.johntopley.com/kb/java/0038.html

Regards,
Bill K.