"Scott Purcell" <[EMAIL PROTECTED]> 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: > org.gjt.mm.mysql.Driver > > > 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 container? > > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, March 07, 2005 3:48 PM > To: Scott Purcell > Cc: mysql@lists.mysql.com > Subject: Re: database pooling problem > > > "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
