proxool-developer

[Proxool-developer] Mercifully killing all current connections because of definition changes

[Pratik M. <pr...@ar...>]

Hi All,
I have just started using proxool.
and facing strange problem on my webserver.

Proxool keeps on opening connection and closing the same.=20

and I receive this final message for each connection.
I did call shutdown() method of facade but even after that this same =
thing starts.

My server finally gives  out of memory message can anyone pl. help me on =
this.
I am using latest proxool and tomcat 4.

Billow is the message.

Best Regards,
Pratik Machchar

Mercifully killing all current connections because of definition changes
DEBUG - 000188 -000004 (00/00/00) - #0192 removed because definition has =
changed.
DEBUG - 000188 -000004 (01/01/00) - Connection #193 created on demand =
=3D ACTIVE
DEBUG - Redefining definition
DEBUG - Recognised proxool property: =
proxool.driver=3Dcom.mysql.jdbc.Driver
DEBUG - Recognised proxool property: =
proxool.url=3Djdbc:mysql://localhost/aruhat?user=3Daruhat&password=3Daat3=
21
DEBUG - Delegating property to driver: user=3Droot
DEBUG - Delegating property to driver: password=3D********

Re: [Proxool-developer] Mercifully killing all current connections because of definition changes

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

Hi Pratik,

Pratik Machchar wrote:

> Proxool keeps on opening connection and closing the same.
[snip]
> Mercifully killing all current connections because of definition changes
> DEBUG - 000188 -000004 (00/00/00) - #0192 removed because definition has 
> changed.
> DEBUG - 000188 -000004 (01/01/00) - Connection #193 created on demand = 
> ACTIVE
> DEBUG - Redefining definition

I'm not sure how long you have been running the app but 192+ connections 
sounds like a lot. The "because of definition changes" bit of the log 
leads me to believe that you are redefining the pool frequently which 
I'm assuming isn't your intention.

The most likely cause is that you are giving the full URl each time you 
request a connection. This is fine, but I wonder whether you have two 
different URLs? If they both share the same pool alias then the same 
pool will constantly be redefined.

I suggest either:

a) you check that the URL you are using is the same for each request, or

b) you configure the pool (see the doc for the various ways you can do 
this) and just use the simpler URL that includes just the alias. Like 
this: "proxool.aruhat". See 
http://proxool.sourceforge.net/quickStart.html for more information.

Let the list know how you get on, please.

Cheers,
Bill

Re: [Proxool-developer] Mercifully killing all current connections because of definition changes

[Pratik M. <pr...@ar...>]

Hi Bill,
Thanks for your help.
the message if I am right means that proxool has created connection =
#0192 and destroyed then created connection #193 and destroyed.
This continues almost every few seconds my thread is requesting the =
connection.
Here is my code to get Connection.

Connection cn=3D null;
  ResourceBundle r =3D ResourceBundle.getBundle("proxoool");
  try{
   Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
      String cnStrg =3D "proxool.sms:" +r.getString("driver")+":"+ =
r.getString("constring") ;
      cn =3DDriverManager.getConnection(cnStrg , =
r.getString("user"),r.getString("password"));

  }
  catch(Exception e){
   Smslog.append(e);
  }
  return cn;

I have not change the resourceBundle proxool. But I did change some =
other ResourceBundle .

Thanks in Advance,

Best Regards,
Pratik Machchar
  ----- Original Message -----=20
  From: Bill Horsman=20
  To: pro...@li...=20
  Sent: Friday, September 23, 2005 11:56 PM
  Subject: Re: [Proxool-developer] Mercifully killing all current =
connections because of definition changes


  Hi Pratik,

  Pratik Machchar wrote:

  > Proxool keeps on opening connection and closing the same.
  [snip]
  > Mercifully killing all current connections because of definition =
changes
  > DEBUG - 000188 -000004 (00/00/00) - #0192 removed because definition =
has=20
  > changed.
  > DEBUG - 000188 -000004 (01/01/00) - Connection #193 created on =
demand =3D=20
  > ACTIVE
  > DEBUG - Redefining definition

  I'm not sure how long you have been running the app but 192+ =
connections=20
  sounds like a lot. The "because of definition changes" bit of the log=20
  leads me to believe that you are redefining the pool frequently which=20
  I'm assuming isn't your intention.

  The most likely cause is that you are giving the full URl each time =
you=20
  request a connection. This is fine, but I wonder whether you have two=20
  different URLs? If they both share the same pool alias then the same=20
  pool will constantly be redefined.

  I suggest either:

  a) you check that the URL you are using is the same for each request, =
or

  b) you configure the pool (see the doc for the various ways you can do =

  this) and just use the simpler URL that includes just the alias. Like=20
  this: "proxool.aruhat". See=20
  http://proxool.sourceforge.net/quickStart.html for more information.

  Let the list know how you get on, please.

  Cheers,
  Bill


  -------------------------------------------------------
  SF.Net email is sponsored by:
  Tame your development challenges with Apache's Geronimo App Server.=20
  Download it for free - -and be entered to win a 42" plasma tv or your =
very
  own Sony(tm)PSP.  Click here to play: =
http://sourceforge.net/geronimo.php
  _______________________________________________
  Proxool-developer mailing list
  Pro...@li...
  https://lists.sourceforge.net/lists/listinfo/proxool-developer