On 02/11/2011 16:23, David Kirtland wrote: > 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.
Not calling which method? On which driver? How much other old code/libraries are you using, if you're using a 3 year old Tomcat? p > 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 > > 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 > > --------------------------------------------------------------------- > 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 > -- -- [key:62590808]
signature.asc
Description: OpenPGP digital signature