Re: connection pool.. got it figured...

["Brad Stone" <brad@xxxxxxxxxxxx>]

On Wed, 9 Jan 2002 19:41:25 -0500
 "Bharath V.S. Dhurjati" <bharath@pswebworks.com> wrote:
> How many calls to getConnection() are you making during
> the run? In other
> words, how many Connection objects are you using?

I am calling getConnection each time a new set of data is
retrieved.  But I am only using onen connection object.  I
did some debugging in the ConnectionPool object to make
sure.  That's how I knew when I made it static, that it
actually was reusing an existing connection instead of
making a new one each time.

> Is this under the first request to get the report or
> under multiple
> requests/multiple clients?

There is only one client at this time, my application being
called on my PC.

> What are you setting maxConnections while constructing
> the Connection pool?

10

>
> PS: If the DB is Access, not sure if connection pools
> help, since I am not
> sure if the same Access db can be concurrently accessed
> by multiple clients,
> with any degree of scaling.

I agree, but it seems this connection pool is also allowing
me to reusing connection objects instead of creating a new
one each time.