mysql wait_timeout problem commons-pool

[Dennis Bekkering <dj...@gmail.com>]

Hello all,

I am experiecing problems with mysql regarding connection time outs. This
problem cannot be resolved by the pool settings provided or jdbc driver
settings such as autoReconnect. Here is a more detailed explaination about
the problem (from tss).

-------------
A new feature that I'd really like to see in DBCP 1.3 is a time-to-live for
Connections. In particular with MySQL, such a feature is very helpful,
because MySQL Connections can start showing strange behavior when the
underlying connection has been terminated and implicitly reconnected.

Note that such a setting should not regard whether the connection has been
active or idle: After the specified amount of time, it should be closed and
removed from the pool in any case.

A validation query doesn't help in the MySQL scenario: The driver will
automatically reconnect and successfully execute the query, but the
Connection still has a chance of remaining in an inconsistent state. This
won't happen on every reconnect, just on some.
-------

Does anybody know about this problem and what to do about it?

Cheers,
Dennis