Hi Trond,
When you change the driver property of a connection pool, pool will be
reconfigured and hence all the connections will be destroyed and the
pool will be initialized again.
There isn't a straight forward way of killing the connections. [This is
being proposed]
* You should disable *all* the jdbc-resources that use the pool so as to
destroy the connections in the pool [This is implementation detail which
may change in future releases]
* Probably the right approach will be to recreate (destroy & create) the
pool.
Thanks,
-Jagadish
On Thu, 2009-01-15 at 21:30 +0100, Trond Strømme wrote:
> Hi Jagadish.
> I'm uncertain wheter we speak of the same thing, this is not about pool
> reconfiguration.
> I simply want to close any connections the pool keeps open.
>
> .trond
> Jagadish Prasath Ramu wrote:
> > Hi Trond,
> > Can you try disabling the application, reconfigure the connection pool
> > and enable the application back ?
> > As long as no instance of the application component is holding the
> > reference to the jdbc-resource (DataSource) during pool reconfiguration,
> > it should work fine.
> >
> > Thanks,
> > -Jagadish
> >
> >
> > On Thu, 2009-01-15 at 12:35 +0100, Trond Strømme wrote:
> >
> >> Hi.
> >> On GlassFish 2ur2 when I disable a JDBC resource will the connections
> >> that have been established in the associated the pool remain connected?
> >>
> >> For maintenance I'd like to disable the applications utilizing a pool,
> >> disable the pool and then close all connections in the pool, thus
> >> freeing the database to be able to change a schema or similar. Currently
> >> I have to stop glassfish in order to actually close the connections to
> >> Oracle.
> >>
> >> Ideally the functionality, if it does not exist, should be avaliable
> >> through both the web admin and asadmin. Alternatively if this is
> >> something that is exposed through an MBean somewhere i can write a small
> >> script that does this for me.
> >>
> >> Thanks,
> >> Trond Strømme
> >> Sun Microsystems Scandinavia
> >> +47 975 09 388
> >>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> >> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
> >>
> >>
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> > For additional commands, e-mail: users-help_at_glassfish.dev.java.net
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>