Re: [OT] Tomcat Connection Pool

[Christopher Schultz <ch...@christopherschultz.net>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Rahul,


(Marking off-topic as this a JDBC driver/database issue unrelated to
Tomcat).

On 2/23/2011 9:13 AM, Rahul Kumar wrote:
> Tomcat version: 6.0

Not that it matters, but what version of 6.0? There are 32 or so of them.

> Problem Statement:
> 
> When server is idle for long period of time thread hangs for waiting
> the DBMS to return with response.

How long is "long"?

> I have tried all the possible combination configuration for 
> connection pool but could succeed in removing that problem.

Specifically, what have you tried? What were the results?

> validationQuery="select * from dual"

Might I suggest not using SELECT *, even if it's from DUAL? What does
that even return? A single row with a single field whose value is '*'?

>                                                    testOnBorrow="true"
>                                                    testWhileIdle="true"

If you have testWhileIdle=true, server idleness shouldn't affect the
JDBC connections: they are periodically "pinged".

>                                                    timeBetweenEvictionRunsMillis="1800000"
>                                                    minEvictableIdleTimeMillis="1800000"

30 minutes. What is the idle-connection-timeout on any firewall hardware
of software you might have sitting between your app server and your db?

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk1lK2sACgkQ9CaO5/Lv0PDaWQCfa+sXQDyMGRrritbkD1mz3u7j
f48AoLXiu98CEn5Yle1sSdbqoB6otqn1
=lJOm
-----END PGP SIGNATURE-----

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