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 se=
eing
> as the issue only arose on the newer version - and I have replicated th=
is.
>=20
> Anyway, they are now going to work around the issue, not calling that m=
ethod
> 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
>=20
>=20
> Dave Kirtland
> Systems Administrator
> dkirtland@epitiro.com
>=20
> www.epitiro.com
>=20
> T. +44 (0)2920 433 693
> F. +44 (0)2920 433 699
>=20
>=20
> -----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
>=20
> David,
>=20
> 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.
>=20
>> 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.
>=20
> Have you tried:
>=20
> $ grep -i "select_user" `find src -type f`
>=20
> ??
>=20
> Tomcat itself is definitely not doing this to you.
>=20
> -chris
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>=20
--=20
--
[key:62590808]
|