Thanks again, much appricated Nihcolas Orr
-----Original Message----- From: Halstead, Chris [mailto:[EMAIL PROTECTED] Sent: Friday, 4 April 2003 8:31 AM To: Tomcat Users List Subject: RE: 2 Quick Questions: DBCP - ValidationQuery && server.xml - Context -cachingAllowed 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: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Friday, 4 April 2003 8:27 AM To: Tomcat Users List Subject: RE: 2 Quick Questions: DBCP - ValidationQuery && server.xml - Context -cachingAllowed Howdy, >1. What does the ValidationQuery* parameter actually do in DBCP? I would assume (too lazy to check) it's a sanity check SQL query allowing the pool to validate the state of a connection before handing it to a client or after receiving it back from a client and before returning it to the pool. >2. In server.xml, what does the cachingAllowed^ property of Context do? Gets propagated to the directory context in order to let you specify the dir context resources shouldn't be cached. See: javax.naming.DirContext org.apache.naming.resources.BaseDirContext org.apache.catalina.core.StandardContext Yoav Shapira Millennium ChemInformatics ********************************************************************** 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]
