Hi Dirk, Thanks for the info. I was surfing the net today and found out this pretty cool component called C-JDBC http://c-jdbc.objectweb.org/ . Its still in RC status. However I think it is worth checking out. So will try it and let you know the status.
Madhan -----Original Message----- From: Dirk Verbeeck [mailto:[EMAIL PROTECTED] Sent: Friday, February 13, 2004 4:44 AM To: Jakarta Commons Users List Subject: Re: DBCP - Redundant databases 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
