RE: Tomcat 5.5.26 running 'select_user' for every transaction

2011-11-02 Thread David Kirtland
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David, On 11/2/11 11:30 AM, David Kirtland wrote: > Since upgrading from Tomcat 5.5.20 to 5.5.26 (Debian Etch to Lenny > - apt versions) we are seeing a 'select_user' query to the database > for every single transaction. This

Tomcat 5.5.26 running 'select_user' for every transaction

2011-11-02 Thread David Kirtland
Hi, Since upgrading from Tomcat 5.5.20 to 5.5.26 (Debian Etch to Lenny - apt versions) we are seeing a 'select_user' query to the database for every single transaction. This is in addition to a 'select 1' (the configured validationQuery). Obviously this is a big overhead which I don't see that we