users@glassfish.java.net

Re: closing connections in a disabled jdbc connection pool

From: Jagadish Prasath Ramu <Jagadish.Ramu_at_Sun.COM>
Date: Thu, 15 Jan 2009 20:11:01 +0530

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
>