On Mar 13, 2013, at 1:50 PM, Daniel Mikusa wrote: > 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
Created... https://issues.apache.org/bugzilla/show_bug.cgi?id=54693 ...and attached an attempt at a patch. 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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org