proxool-developer

Re: [Proxool-developer] On the fly configuration

[Kiran T <mah...@ho...>]

Is it possible to change the Proxool connection and pool configuration
properties without restarting the application server?

>Yes it is. Look at ProxoolFacade.updateConnectionPool(), and
>redefineConnectionPool().

...But I still have to restart my jvm to read the updated XML or property 
files. I typically want to increase or decrease the number of connections 
depending on the traffic. Can I do it without restarting the server( jvm) ?

_________________________________________________________________
From the hottest toys to tips on keeping fit this winter, you’ll find a 
range of helpful holiday info here.  
http://special.msn.com/network/happyholidays.armx

Re: [Proxool-developer] On the fly configuration

[Christian N. <chr...@em...>]

If you are running in an appserver with a JMX (http://java.sun.com/products/JavaManagement/) console (eg. JBoss) you can make a Proxool pool runtime configurable simply by setting the jmx property to "true".

As of now the changes will not be persisted across server restarts.

Bill:
having a Log4J watcher like functionality seems like a good idea.

CHR


----- Original Message -----
From: "Kiran T" <mah...@ho...>
Date: Wed, 19 Nov 2003 15:48:21 +0000
To: pro...@li...
Subject: Re: [Proxool-developer] On the fly configuration

> Is it possible to change the Proxool connection and pool configuration
> properties without restarting the application server?
> 
> >Yes it is. Look at ProxoolFacade.updateConnectionPool(), and
> >redefineConnectionPool().
> 
> ...But I still have to restart my jvm to read the updated XML or property 
> files. I typically want to increase or decrease the number of connections 
> depending on the traffic. Can I do it without restarting the server( jvm) ?
> 
> _________________________________________________________________
> From the hottest toys to tips on keeping fit this winter, you’ll find a 
> range of helpful holiday info here.  
> http://special.msn.com/network/happyholidays.armx
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?  SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Proxool-developer mailing list
> Pro...@li...
> https://lists.sourceforge.net/lists/listinfo/proxool-developer

-- 
__________________________________________________________
Sign-up for your own personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Search Smarter - get the new eXact Search Bar for free!
http://www.exactsearchbar.com/

Re: [Proxool-developer] On the fly configuration

[Bill H. <bi...@lo...>]

Hi Kiran,

On Wed, 2003-11-19 at 16:48, Kiran T wrote:

> ...But I still have to restart my jvm to read the updated XML or property 
> files. 

0.10 will include that functionality I would think. That is, reloading
XML configuration files at runtime. Or something similar that would have
the same effect. 

In the meantime, you can do it programmatically if you want. For
instance:

  Properties properties = new Properties();
  properties.setProperty("proxool.maximum-connection-count", "20");
  ProxoolFacade.updateConnectionPool("alias", properties);

I admit that's not very elegant compared to the simplicity of updating
an XML file. The focus of 0.10 will be exactly this sort of thing.

What do you people think to Log4J like behaviour where you can configure
Proxool to "watch" an XML file and reload it if it changes?

Regards,

Bill Horsman