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
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

Reply via email to