-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

David,

On 3/18/13 2:07 AM, David Kumar wrote:
>> 1. You are abandoning db connections and thus are draining the
>> pool (most likely in my eyes) 2. The pool is too small (unlikely,
>> since no work seems to be done other than waiting for new
>> connections) 3. Lock contention while going through borrowObject
>> (unlikely, since no thread is doing a validation)
>> 
>> So I would configure 'logAbandoned="true"' and even 
>> 'removeAbandoned="true"' and 'removeAbandonedTimeout="60"' as
>> stated on 
>> http://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples->howto.html.
>
>>  When your pool is getting drained, you will see a message in
>> your log files, where you have taken connections out of the pool,
>> but haven used them for a while. Than you can start to look for
>> places, where those connections might have leaked.
> 
> thanks for that hint, I will have a look at all of my
> databasepools.. Hopefully you're right and that is our problem..

Recommended reading:
http://blog.christopherschultz.net/index.php/2009/03/16/properly-handling-pooled-jdbc-connections/

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEAREIAAYFAlFHMhEACgkQ9CaO5/Lv0PAgVwCfUoMRvSSqqrti566y/YipPTm8
b2QAoLIa3huGEVhwXEj+BnVdWAcrxUL7
=NhLI
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to