0 Replies Latest reply on Aug 14, 2006 7:42 AM by Sergio Martins

    Oracle Cluster using THIN driver

    Sergio Martins Newbie

      Hi all,

      I'm using Jboss 4.0.3SP1 and Oracle JDBC Drivers 9i and 10g (on two different cases) and I need to implement a Database cluster failover on both cases. Using RAC to manage Oracle failover.

      After many searches on web (including Oracle) I saw this type of usage on oracle-ds.xml:


      <jndi-name>OracleDS</jndi-name>
      <connection-url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx1)(PORT=1521))
      (ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SID)(FAILOVER_MODE=(TYPE=select)(DELAY=15)(RETRIES=20))))</connection-url>


      This seems to work fine.

      Does anyone uses it and have experienced any kind of problem?

      Many thanks,
      Sérgio