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. -----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 [email protected] http://maillist.caucho.com/mailman/listinfo/resin-interest _______________________________________________ resin-interest mailing list [email protected] http://maillist.caucho.com/mailman/listinfo/resin-interest _______________________________________________ resin-interest mailing list [email protected] http://maillist.caucho.com/mailman/listinfo/resin-interest
