tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Jones <sc...@on-sitemanager.com>
Subject Re: DBCP Database Connection pooling in TC4
Date Mon, 22 Apr 2002 18:36:27 GMT
Hi John,

Ah, very nice.  That's exactly what I was looking for...  I don't
actually understand why you'd ever want the pool to get reset.  

Before, I actually had JDBC Connection Pooling set up using the
bitmechanic jdbcpool (http://www.bitmechanic.com/projects/jdbcpool/). 
However, I want to use the DataSource interface (or I guess the
ConnectionPoolDataSource interface) to get at my databases so that I can
set the loginTimout and a few other things that this new stuff
provides...  

Thanks for the pointer, I've just checked it out of CVS and will give it
a try.

Cheers,

Scott

On Mon, 2002-04-22 at 11:21, John McNally wrote:
> Hello Scott,
> 
> There is another connection pool located in commons-sandbox/jdbc2pool
> that behaves as you expect, multiple lookups of the same pool will NOT
> reset the pool.  Jdbc2pool is written to use a ConnectionPoolDataSource
> as the backend providing the connections.  It does have an adapter
> package that can be used with the older Driver style of providing
> physical connections.  This adapter adds the benefit of
> PreparedStatement pooling as well.  Jdbcpool has not been put to the
> test in a production system yet, but it does pass its tests and is based
> on the same commons-pool code used in BasicDataSource.
> 
> john mcnally
> 
> Scott Jones wrote:
> > 
> > Hi Chad,
> > 
> > Didn't get your emails until this morning -- are you experiencing the
> > same problems that I was talking about?  Basically, it seems like a new
> > connection pool is getting set up after every JNDI lookup (which I'd
> > basically like to do every time I run a query).   If I hold on to the
> > same datasource, I can see that it's obvious that connection pooling is
> > working...
> > 
> > I've just been doing something like the following the code below to test
> > it out.  However, the thing that I notice is that rerunning this code
> > doesn't hold on to the original pool -- in the following code segment
> > the first and second connections are always > 50ms to get and the last
> > one (which comes from the pool) is always around 0-1ms.  It seems to me
> > that the DataSource should get "cached" or held on to in some way --
> > Otherwise, it seems like it's defeating the purpose of connection
> > pooling!!!
> 
> --
> To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
> Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>
-- 
Scott Jones
On-Site Manager, Inc.
scott@on-sitemanager.com
8-ONSITEMGR (866-748-3647)

--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message