users@glassfish.java.net

Re: closing connections in a disabled jdbc connection pool

From: Trond Strømme <Trond.Stromme_at_Sun.COM>
Date: Thu, 15 Jan 2009 21:30:11 +0100

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
>
>