Re: [enhydra] Enhydra database connection pool and MySQL problems

[Petr Stehlik <pstehlik@xxxxxxxxxx>]

V Pá, 04. 06. 2004 v 13:47, Petr Stehlik píše:
> Reading through the DODS documentation I found two directives I didn't
> know about: MaxConnectionUsages and MaxWaitingConnections.
> 
> Do I understand it correctly that setting the MaxWaitingConnections to 0
> basically disables the connection pool and thus fixes the problem with
> MySQL?

Replying 7th time to myself today but anyway - the MaxWaitingConnections
set to 0 probably effectively disables the database connection pool and
thus fixes (or better works around) the problem with MySQL and
Connector/J (the MySQL JDBC driver).

The price for this workaround is obviously a slowdown of all database
operations so a real solution (configurable timeout or better check for
discarded connections) to the original problem (idle connections are
discarded by the MySQL server) would be welcome.

Petr