Is anyone here using it via a Singleton pattern? I'm trying to figure out the best way to use this...
Currently, we have an object that gets a database connection (with no pooling), and I'm trying to snap DbConnectionPool in with it. I have two static variables within the object now, one for db connection pool reference (that only gets initialized once) and a variable for a connection (public). In the constructor of this object, I check to see if connection is null or closed. If it is, I get another connection from dbpool. When I do stress testing with Apache JMeter, I'm getting lots of errors like this: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt Can you see holes in my logic? Should I just create a method that doles out a connection, and another that calls freeConnection after I'm done with it? The only reason I don't do this now is because all the changes I'll have to make to accomodate this. TIA, ----- Original Message ----- From: "Jim Urban" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 24, 2002 9:20 AM Subject: RE: Pooling database connections: best practices? > I concur, we've been using DbConnectionPool for over year with no problems. > We've used it with Oracle, MS-SQL and MySQL with no problems. > > Jim Urban > Product Manager > Netsteps Inc. > Suite 505E > 1 Pierce Pl. > Itasca, IL 60143 > Voice: (630) 250-3045 x2164 > Fax: (630) 250-3046 > > > -----Original Message----- > From: Michael Molloy [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 24, 2002 9:13 AM > To: Tomcat Users List > Subject: Re: Pooling database connections: best practices? > > > Also DbConnectionPool at www.javaexchange.com. Don't know about the one > mentioned below, but the one at JavaExchange is free. Working very well for > me. > > --Michael > > On Thursday 24 January 2002 10:56 am, you wrote: > > just use a 3rd party component. > > check out the www.bitmechanic.com JDBC-Pool. > > have a nice day > > -reynir > > > > > > -----Original Message----- > > From: Sean LeBlanc [mailto:[EMAIL PROTECTED]] > > Sent: 24. jan�ar 2002 16:00 > > To: [EMAIL PROTECTED] > > Subject: Pooling database connections: best practices? > > > > > > I'm just wondering what kind of best practices are recommended for > > pooling > > database connections - with Tomcat and perhaps JSP/Servlets in general. > > > > Thanks, > > Sean LeBlanc > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
