It isn't something obvious built into our webapp, but it would seem to be a method we are calling in the jdbc driver. There is no record of a 'select_user' anywhere when doing a grep, but our Java developers have found the issue now. The code wasn't changed between versions which is odd seeing as the issue only arose on the newer version - and I have replicated this.
Anyway, they are now going to work around the issue, not calling that method any more. If I find the exact method it is off them I will re-post. Thanks Dave Kirtland Systems Administrator dkirtl...@epitiro.com www.epitiro.com T. +44 (0)2920 433 693 F. +44 (0)2920 433 699 -----Original Message----- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: 02 November 2011 16:01 To: Tomcat Users List Subject: Re: Tomcat 5.5.26 running 'select_user' for every transaction -----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 is in addition to a 'select 1' > (the configured validationQuery). Obviously this is a big overhead > which I don't see that we need. > > If anyone can shed some light on what this is doing and why it's > there (and ideally if we can turn it off) that would be very > helpful! I've searched through the docs and can't really find any > reference to it. Have you tried: $ grep -i "select_user" `find src -type f` ?? Tomcat itself is definitely not doing this to you. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk6xaR8ACgkQ9CaO5/Lv0PBiuwCghQSFbfaAC19+1Pbd4GB5v0u9 5m8AoLsSM2qS7R54Ebx7scZGZGyqoWrv =oFoL -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org