commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dennis Bekkering" <djdenn...@gmail.com>
Subject mysql wait_timeout problem commons-pool
Date Fri, 21 Jul 2006 19:52:25 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message