Hi,
I am using connection pools as described in the examples and documentation
that comes with the dbcp release, however those examples suggest the use of
jdbc.drivers property to specify the driver. I don't want to do this since
my application is web-based, so I changed the code to use a
DriverConnectionFactory instead of DriverManagerConnectionFactory:
ConnectionFactory connectionFactory
= new DriverConnectionFactory(
(Driver)Class.forName(driver).newInstance()
,connectURI, props);
I would like to know if this is correct and if it should work the same as
the original code.
I made a servlet using the connection pool and tested it with JMeter. The
result was that the code that used the pool was always slower than the one
not using the pool, despite the fact that the graphs provided by JMeter was
quite different: the one without the pool looks like a logarithm and the one
with the pool looks like a poisson distribution, both making sense to me.
Thanks,
Otto.
----- Original Message -----
From: "robert burrell donkin" <[EMAIL PROTECTED]>
To: "Jakarta Commons Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 4:28 PM
Subject: Re: Using connection pools
>
>
> hi Otto
>
> could you remember to prefix your post(s) with the name of the components?
>
> (this simple rule means that those people who are concerned about that
> particular component will be able to respond more quickly.)
>
> - robert
>
> On Wednesday, November 6, 2002, at 08:32 PM, Otto Cordero wrote:
>
> > Hi,
> > I am using PoolingDataSource to pool connectiosn to my database. I would
> > like to get a log of the usage of connections in the pool. I suppose
that
> > setLogWriter in PoolingDataSource sets the log, but it writes nothing to
> > it.
> > How can I log database activity and pool usage?.
> >
> > Thanks,
> > Otto.
> >
> >
> > --
> > To unsubscribe, e-mail:
> <mailto:commons-user-unsubscribe@;jakarta.apache.
> > org>
> > For additional commands, e-mail:
> <mailto:commons-user-help@;jakarta.apache.
> > org>
> >
>
>
> --
> To unsubscribe, e-mail:
> <mailto:commons-user-unsubscribe@;jakarta.apache.org>
> For additional commands, e-mail:
> <mailto:commons-user-help@;jakarta.apache.org>
>
--
To unsubscribe, e-mail: <mailto:commons-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:commons-user-help@;jakarta.apache.org>
