On Wed, 28 Aug 2002, Turner, John wrote:
> Date: Wed, 28 Aug 2002 14:17:49 -0400
> From: "Turner, John" <[EMAIL PROTECTED]>
> Reply-To: Tomcat Users List <[EMAIL PROTECTED]>
> To: 'Tomcat Users List' <[EMAIL PROTECTED]>
> Subject: RE: tomcat conn pooling question
>
>
> How does the admin app know what query to generate? The query it generated
> would have to have valid column names and table names. I guess it could
> just create "select foo from bar", but that doesn't seem any more helpful
> than an empty string.
The admin app does *not* generate the query -- you have to type in a query
that makes sense for your application.
The bug referenced in this mail thread is that if you *don't* specify a
query, the admin app should not pass a zero-length string to the
connection pool -- it should simply not initialize that property.
Craig
>
> John Turner
>
> > -----Original Message-----
> > From: Craig R. McClanahan [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 28, 2002 2:14 PM
> > To: Tomcat Users List
> > Subject: RE: tomcat conn pooling question
> >
> >
> >
> >
> > On Wed, 28 Aug 2002, Andrew Conrad wrote:
> >
> > > Date: Wed, 28 Aug 2002 13:10:30 -0400
> > > From: Andrew Conrad <[EMAIL PROTECTED]>
> > > Reply-To: Tomcat Users List <[EMAIL PROTECTED]>
> > > To: 'Tomcat Users List' <[EMAIL PROTECTED]>
> > > Subject: RE: tomcat conn pooling question
> > >
> > > Thx.
> > >
> > > A validationQuery is not required by DBCP, but if you pass an empty
> > > string it throws an exception.
> > >
> > > Tomcat's admin app for JNDI DataSources creates a
> > Validation Query with
> > > an empty string if no query is supplied, causing DBCP to throw an
> > > exception when invoked. In your opinion, is this a mistake
> > by the Admin
> > > app for creating a empty string parameter, or a mistake by DBCP in
> > > handling an empty string?
> > >
> >
> > IMHO that's an admin app bug.
> >
> > > - Andrew
> >
> > Craig
> >
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
