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

> Thanks Sean,
> I am using standalone Apache/Tomcat 4.1.31
> mysql> \s
> --------------
> mysql  Ver 12.21 Distrib 4.0.15, for Win95/Win98 (i32)
> Connection id:          184
> SSL:                    Not in use
> Server version:         4.0.15-max-debug
> Protocol version:       10
> Connection:             localhost via TCP/IP
> Client characterset:    latin1
> Server characterset:    latin1
> TCP port:               3306
> --------------
> mysql>
> I am using Java to code with and I am using a driver called: 
> My connection class is too large to submit to the list, or I would 
submit it.
> I guess what I would like to be able to do is create some type of 
> object that I could use to do pooling that is maybe inside the 
> I hope this helps,
> Scott

It would be happy to try to help if I worked in or on either of those 
platforms (Apache + Java).  I am Win32(IIS), ASP (VBScript/JavaScript) 
using MyODBC as my connection library. Sorry but I can't help in any way 
shape or form. I have CC-ed the description of your operating and 
development environments to the list to see if anyone offers to help.

Maybe next time!

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

> -----Original Message-----
> From: SGreen@stripped [mailto:SGreen@stripped]
> Sent: Monday, March 07, 2005 3:48 PM
> To: Scott Purcell
> Cc: mysql@stripped
> Subject: Re: database pooling problem

> "Scott Purcell" <spurcell@stripped> wrote on 03/07/2005 04:29:18 
> > 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 
> > 
> > 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
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