"Scott Purcell" <[EMAIL PROTECTED]> 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
