-----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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org