fail over and load balance in jdbc url

ahem.shaikh Dec 20, 2012 2:58 AM

Hi,

I use below jdbc url in my application running on jboss 4.2.2 version.

<connection-url>

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=db02-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=db01-vip)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=GDB.ada.com)))

</connection-url>

Recently one of the db node was down and my application did not connect to another db nodeeven though i am using FAIL OVER=ON option in my jdbc url. Any idea why this happened.

Regards,

Ahmed.