tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pid <...@pidster.com>
Subject Re: Tomcat 5.5.26 running 'select_user' for every transaction
Date Wed, 02 Nov 2011 21:20:06 GMT
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
> dkirtland@epitiro.com
> 
> www.epitiro.com
> 
> T. +44 (0)2920 433 693
> F. +44 (0)2920 433 699
> 
> 
> -----Original Message-----
> From: Christopher Schultz [mailto:chris@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-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
> 

-- 
--

[key:62590808]


Mime
View raw message