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