tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Kirtland <>
Subject RE: Tomcat 5.5.26 running 'select_user' for every transaction
Date Wed, 02 Nov 2011 16:23:10 GMT
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.


Dave Kirtland
Systems Administrator

T. +44 (0)2920 433 693
F. +44 (0)2920 433 699

-----Original Message-----
From: Christopher Schultz []
Sent: 02 November 2011 16:01
To: Tomcat Users List
Subject: Re: Tomcat 5.5.26 running 'select_user' for every transaction

Hash: SHA1


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
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools -
Comment: Using GnuPG with Mozilla -


To unsubscribe, e-mail:
For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message