List:General Discussion« Previous MessageNext Message »
From:SGreen Date:March 7 2005 9:47pm
Subject:Re: database pooling problem
View as plain text  
"Scott Purcell" <spurcell@stripped> wrote on 03/07/2005 04:29:18 PM:

> Hello,
> 
> I am working with a traditional database pooling class basically 
> putting connection objects into a Vector.  When I run the code from 
> a main, it appears solid. I have run 10s of thousands of back to 
> back queries and all is good.
> 
> Problem is when I connect it to a web-app, and reboot the webserver 
> a couple of times, I get a message from the driver stating "Too many
> connection" and I am done.
> 
> Upon thinking about this, I figured my traditional Vector of 
> connections, is getting created over and over, each time someone 
> "bumps" the web server with a new class, etc. So I start out with 10
> connections, then another 10 and another 10 and eventually I guess 
> the driver has no more connections to give?
> 
> Anyway, this list is possibly the wrong, list, but I would hope 
> there are some developers here that may lend a hand or link. So I am
> not happy with what I have created nor the way it works on the web 
server.
> 
> Does anyone have any ideas how I should handle this? in a web-based 
> environment.
> 
> Thanks,
> Scott
> 
> 

No matter which list you submit to, you need to provide more details. 
Technically what you are asking is a little off-topic (more about making a 
pool work with a web server than just making the connection, right?) But 
if you bring the question to the list, someone _may_ be able to pitch in 
and help.

Now exactly WHO can help (and to what degree they can help) completely 
depends on WHICH web server you use (there are dozens, you know...), HOW 
you initialize your pool (again many methods available), HOW you take and 
return connections from your pool (ditto), and which languages are in use 
in this entire process (again dozens of options). Just telling us that you 
use a web-server did not provide nearly enough information as there are 
literally thousands of combinations of ways to do what you described.

Please tell whichever list you submit to:
        What OS you are using
        Which web server you are using
        What languages you are using

And you will need to supply some code examples, too. The list members will 
need to be able to see your code so that they can see what is "wrong" with 
it. 

Best of luck,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Thread
database pooling problemScott Purcell7 Mar
  • Re: database pooling problemSGreen7 Mar
RE: database pooling problemSGreen7 Mar
  • Re: database pooling problemEric Bergen8 Mar
    • Re: database pooling problemWilliam R. Mussatto8 Mar
  • IIS, ASP, MySQL (was: database pooling problem)Robert Citek6 Apr
    • Re: IIS, ASP, MySQL (was: database pooling problem)SGreen6 Apr
    • Re: IIS, ASP, MySQL (was: database pooling problem)Florin Andrei6 Apr