-----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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
