On Mar 13, 2013, at 1:14 PM, Christopher Schultz wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA256 > > Dan, > > On 3/13/13 10:12 AM, Daniel Mikusa wrote: >> On Mar 13, 2013, at 3:49 AM, Dunn, Rob wrote: >> >>> Commons-dbcp 1.4 supports a validationQueryTimeout property. The >>> tomcat7 tomcat-jdbc connection pool >>> (https://urldefense.proofpoint.com/v1/url?u=http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html&k=oIvRg1%2BdGAgOoM1BIlLLqw%3D%3D%0A&r=8LKtd%2FtAZDTpwjGeWvVQiUwkyBqCv2FEneWpUZu8YLo%3D%0A&m=GVZLVYWRq7pdCsaexj2BhgF4WD6a2XE7cPmp2QLZqV8%3D%0A&s=88a37d5288d99be5827fb4f5996596f17c7c19d4b190a18d1cfd1f891ad3ec57) >>> >>> > does not support this. >> >> Funny, I was just looking at the same thing yesterday. >> >>> Has anyone found a way to configure a validation query timeout >>> or achieve similar functionality to commons-dbcp-1.4 in tomcat >>> 7's tomcat-jdbc connection pool? >> >> I couldn't find an option, like with DBCP, to do this. My thought >> was to write a custom connection validator and use >> "validatorClassName" instead. Not the cleanest approach since I >> have to re-implement the validation logic, but it'll let me set >> the timeout. > > Seems like patching tomcat-pool would be a much easier solution. Care > to try your hand at a patch?
Agreed. I'll give it a shot, seems simple enough. Dan > > - -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/ > > iEYEAREIAAYFAlFAtBAACgkQ9CaO5/Lv0PB4/wCfWfGXlEdAFXRRZpTEtGpVwMkF > gD0AoIeQB6z6ZsaS2YTpR5pqnve3cQ14 > =GF1a > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
