commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "G. Madhan Dennis" <>
Subject RE: DBCP - Redundant databases
Date Fri, 13 Feb 2004 05:12:44 GMT
Hi Dirk,

Thanks for the info. I was surfing the net today and found out this
pretty cool component called C-JDBC . Its
still in RC status. However I think it is worth checking out. So will
try it and let you know the status.


-----Original Message-----
From: Dirk Verbeeck [] 
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:

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
> replicated databases. We configure DBCP to connect to the primary db.
> However if it goes down DBCP needs to reconnect to the secondary db.
> 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:///\\> 
> ----------------------------------------------------------------- 
>  ,_, 
> (O,O) Opportunity is missed by most people, 
> (   ) because it is dressed in overalls and looks like work. 
> -"-"------------------------------------------------------------- 

To unsubscribe, e-mail:
For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message