0 Replies Latest reply on Aug 20, 2004 7:41 AM by sheckler

    Oracle 9.2 TAF with JBoss 3.2.5

    sheckler

      Hi all,
      I would like to use "Transparant Application Failover" (TAF) with my JBoss.
      What programmatic changes are necessary in my source code, what configurative changes in the JBoss configuratation files?

      Im am using the following connection URL

      <connection-url>jdbc:oracle:oci:@CMD-DBR1</connection-url>


      with the following TNSNAMES Entry:

      RWCO_DBS =
      (DESCRIPTION =
      (FAILOVER = ON)
      (LOAD_BALANCE = ON)
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rwco_dbs1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = rwco_dbs2)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = eedb)
      (FAILOVER_MODE =
      (TYPE = SELECT)
      (METHOD = PRECONNECT)
      (RETRIES = 20)
      (DELAY = 3)
      )
      )
      )

      and JBoss uses direct JDBC calls (ServerLogon Modul, SecurityProxy etc.), as well as CMP- and BMP-Beans to access the database.

      Thanks for all Your hints.

      Stefan