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?
Paul Phillips
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
