RE: 2 Quick Questions: DBCP - ValidationQuery && server.xml - Con text -cachingAllowed

[Nicholas Orr <Ni...@mim.com.au>]

Thanks again, much appricated

Nihcolas Orr


-----Original Message-----
From: Halstead, Chris [mailto:Chris.Halstead@delta.com] 
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:Yoav.Shapira@mpi.com] 
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:	supportcentre@mim.com.au
Support Centre phone:  	Australia 1800500646
        				International ++61 7 38338042
**********************************************************************


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org