>We use both C3P0 and DBCP exactly for that purpose; we read information from >a separate configuration file found on the classpath, build a connexion >pool, and register the pool by calling the JNDI API. > >In our experience, C3P0 is a touch faster and more stable than DBCP, but the >error messages from DBCP are cleaner. For example, if you can't login to >the database, C3P0 tends to wrap the message in a generic "could not connect >after n tries" and you have to go dig in the logs to see the actual cause, >whereas DBCP gives the root cause. > >Jean-François Lamy >Teximus >+1 514 878-1577 x222 > > > >-----Message d'origine----- >De : [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] De la part de Mike Wynholds >Envoyé : 14 septembre 2007 17:08 >À : General Discussion for the Resin application server >Objet : Re: [Resin-interest] Runtime creation of database connections pools > >at lost of people like c3po - http://sourceforge.net/projects/c3p0 >dbcp is also good - http://commons.apache.org/dbcp/ > >I think they both will let you pool things in code. >.m. > I've been using Proxool for 3+ years. It's been very stable and can be configured programatically as well as well XML or properties.
I'm using the older version 0.8.3, but 0.9 release candidates have been out for a while. <http://proxool.sourceforge.net/> <http://proxool.sourceforge.net/configure.html> Regards, Barrie Selack >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Eric Kreiser >Sent: Friday, September 14, 2007 1:11 PM >To: Resin Group >Subject: [Resin-interest] Runtime creation of database connections pools > >Does resin support this... and if so... can someone point me in the >right direction. If not... does anyone recommend another database >connection pooling api which does support this? > >I have found myself in a situation where I need to create my database >connection pools in code at runtime not based on the resin.conf. I want > >to be able to pool my connections, but there are too many potential >database/user combinations to manage configuring all of them in the >resin.conf. > >thanks in advance for any help you are able to supply. > > >_______________________________________________ >resin-interest mailing list >resin-interest@caucho.com >http://maillist.caucho.com/mailman/listinfo/resin-interest > > >_______________________________________________ >resin-interest mailing list >resin-interest@caucho.com >http://maillist.caucho.com/mailman/listinfo/resin-interest > > > >_______________________________________________ >resin-interest mailing list >resin-interest@caucho.com >http://maillist.caucho.com/mailman/listinfo/resin-interest > _______________________________________________ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
