0 Replies Latest reply on Dec 20, 2012 2:58 AM by Ahmed N

    fail over and load balance in jdbc url

    Ahmed N Newbie

      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.