-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Gregor,

Filip Hanik - Dev Lists wrote:
> The JDBC realm doesn't use the connection pool you've specified below,
> The JDBC realm uses a single connection, never closes it unless an
> exception happens.

Might I suggest using a JNDI Realm so you can share your configuration
between your Realm authenticator and your application?

MySQL or a piece of network hardware might be shutting-down your
connection after 8 hours. By using the JNDI pool you have configured,
DBCP ought to get you a good connection even after that 8 hours has elapsed.

Definitely don't use MySQL's auto-reconnect feature. I'm not sure why
that even still exists in the 5.x version of the driver. They have been
declaring it unfit for use for years.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGkmUI9CaO5/Lv0PARAomJAJwPsoTiS74oRaANdRVs4sK1wJygaQCfQKIP
x2BJiJA2i3XQUoNSxI2SL9s=
=avI4
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To start a new topic, e-mail: users@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)