Currently DBCP doesn't provide any load-balancing/failover services. There is an enhancement request: http://issues.apache.org/bugzilla/show_bug.cgi?id=25511
But no action has been taken to implement this feature.
I would implement it by defining 2 normal datasources and then a new kind of datasource that does the load-balancing/failover.
Probably similar to your solution.
In the bugzilla request there is an alternative component that does clustering. (Didn't try it yet)
-- Dirk
G. Madhan Dennis wrote:
Hi Everyone,
Is it possible to handle db redundancy in the Commons-DBCP? We have two
replicated databases. We configure DBCP to connect to the primary db.
However if it goes down DBCP needs to reconnect to the secondary db. How
do I do that? I have currently arrived at a solution which involves
using two connection pools, one for each database and alternating them
whenever a connection fails. Is there any other way to do this?
Thanks Regards, G. Madhan Dennis Senior Systems Engineer iSoftel India Hand Phone: +91 98942 22987 ----------------------------------------------------------------- Enabling Technologies for Carrier Services Visit us at <file:///\\www.isoftel.com> www.isoftel.com ----------------------------------------------------------------- ,_, (O,O) Opportunity is missed by most people, ( ) because it is dressed in overalls and looks like work. -"-"-------------------------------------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
