RE: validationQuery: If you specify a validationQuery in a DBCP configuration the pool will automatically apply that validation query to connections before handing them to application code (testOnBorrow becomes implicitly true). If the validation query fails, the connection will be dropped from the pool. This adds a bit of overhead, but will effectively prevent your application from obtaining an invalid connection - a Good Thing(TM) IMHO. If validationQuery is non-null you can also choose to enable testOnReturn and testWhileIdle, but I'm not personally convinced that those have much real value.
-chris -----Original Message----- From: Nicholas Orr [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 5:07 PM To: 'Tomcat Mailing List' Subject: 2 Quick Questions: DBCP - ValidationQuery && server.xml - Context -cachingAllowed Hello, Just two quick questions 1. What does the ValidationQuery* parameter actually do in DBCP? 2. In server.xml, what does the cachingAllowed^ property of Context do? Thanks, Nicholas Orr *I looked in the TC 4.1.24 doc but it was not there, then went to dbcp website and I didn't know where to look there. ^I looked in the TC 4.1.24 doc but it was not there. ********************************************************************** The information contained in this e-mail is confidential and is intended only for the use of the addressee(s). If you receive this e-mail in error, any use, distribution or copying of this e-mail is not permitted. You are requested to forward unwanted e-mail and address any problems to the MIM Holdings Limited Support Centre. For general enquires: ++61 7 3833 8000 Support Centre e-mail: [EMAIL PROTECTED] Support Centre phone: Australia 1800500646 International ++61 7 38338042 ********************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]