tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: Tomcat 6.X and MySQL connection pooling issue
Date Thu, 01 Oct 2009 16:05:25 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Mark et al,

On 9/30/2009 8:33 AM, Mark Thomas wrote:
> It just means that testOnBorrow does nothing if validationQuery is set to "".
> For mysql "select 1" is sufficient and saves a call to now(). The Oracle
> equivalent would be "select 1 from dual"

FYI, for recent versions of MySQL Connector/J, a better test query would be:

/* ping */ SELECT 1

This will perform a lighter-weight connection test than would be
required in order to actually issue a query, have the server parse it,
execute it, and return the result to the client.

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

iEYEARECAAYFAkrE00UACgkQ9CaO5/Lv0PBbAQCgr0TbDe+XnQlS84bOTkrATCxp
DxoAoIk7j+KKG+WKHY5e9hwVMjdPy6f5
=UK40
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message