On Wed, 28 Aug 2002, Paul Phillips wrote:
> Date: Wed, 28 Aug 2002 19:40:45 -0500
> From: Paul Phillips <[EMAIL PROTECTED]>
> Reply-To: Tomcat Users List <[EMAIL PROTECTED]>
> To: Tomcat Users List <[EMAIL PROTECTED]>
> Subject: RE: tomcat conn pooling question
>
> Hello -
>
> Earlier today, Craig wrote:
> >
> > In answer to Rick's original question, the standard connection pool
> > includes a "validationQuery" configuration property. This is an SQL query
> > that the pool will execute before it hands you back a requested
> > connection (so it should be something that executes very quickly). If the
> > connection was closed externally (your scenario), this query will fail and
> > the pool will throw that connection away and give you another one instead.
> >
>
> So, in a JNDI DataSource configuration, in the server.xml, I suppose that
> we would have something like:
>
> <parameter>
> <name>validationQuery</name>
> <value>SQL_here</value>
> </parameter>
>
> Am I correct in surmising that we would put an actual SQL query within the
> <value></value> tags?
>
Yes.
> Paul Phillips
>
Craig
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
