JDBC for Active-Active Oracle Primary/Failover DB
843859Aug 11 2006 — edited Aug 11 2006Hi,
Currently for our application we use an Oracle Primary (Active) and FailOver (Passive) setup. To connect to these databases, we use two JNDIs and use JDBC thin driver. Say when a Failover (FO) occurs, we have a logic to use the FO JNDI and connect to the FO DB.
But in future we are planning to have both Primary and FO as Active-Active configuration. So accd to Websphere there should be one URL (JDBC thin driver), but it should be able to connect to two datasources. I came to know that the driver will take care of this. Is this possible? If so please explain how? Thank you!