On Sat, 14 Apr 2001, Waldhoff, Rodney wrote:
> "Ignacio J. Ortega" wrote:
>
> > How i suppoused a DBCP is shutdown?
> >
> > Which is the way to release all
> > connections or better, restart them,
> > without rebuild the pool, or shutdown
> > and restart it ?
>
> I can't say that this is something I've had much need to do. (We run
> multiple servers in production, so normally I'd just bounce one server at at
> time to do something like this.)
>
> The clear method of ObjectPool could be helpful here, although it's actually
> a bit tricky. The trouble is the pool only tracks the objects (in our case)
> connections that are idle. You can clear those easily, but the
> outstanding/active connections won't be touched.
>
> It might help if I had a better idea of precisely what you are trying to do.
> Simply shutdown cleanly? Change the database you're connecting to? Recover
> from a bounced DB?
>
I'd like to see us support the first and third items on this list (clean
shutdown and db-recovery). The second is not something I would do -- I
would go create a new pool for that.
> > I'm about to add a new constructor method to
> > DriverManagerConnectionFactory to use the
> > abreviated syntax DMCF(url,username,password)
> > that mimics the original JDBC DriverManager
>
> Feel free.
>
> > Is the correct protocol is to add my name to
> > the list of committers on status.html and
> > start doing commits ?
>
> Yes, that's my understanding as well.
>
Yep.
Craig