Oracle database cluster

[sheckler]

Hi,
I would like to start with Oracle 9.2 (JBoss 3.2.1) and connect to a Oracle database cluster.

How to configure JBoss to switch between 2 oracle instances, if one of them is shut down?

Thanks
Stefan

[schmidts]

Assuming you mean Oracle RAC (previously known as Parallel Server), you'll need to use the OCI JCDBC driver (aka "thick" JDBC driver) and have an appropriate tnsnames-configuration. When setup correctly, this makes the jdbc driver choose an available database server at connect-time.
Oracle's so called "Transparant Application Failover" (TAF) in read/write-transactions doesn't come for free as it requires programmatic support in the application.
Anyway, consult with your DBA about tnsames and check the Oracle documentation.

[sheckler]

Yes I mean RAC. If I understand You correctly, I just have to specify an other JDBC driver in the oracle-ds.xml? And then the failover logig comes from the driver?
This would be fine for me!

[sheckler]

"schmidts" wrote:
Assuming you mean Oracle RAC (previously known as Parallel Server), you'll need to use the OCI JCDBC driver (aka "thick" JDBC driver) and have an appropriate tnsnames-configuration. When setup correctly, this makes the jdbc driver choose an available database server at connect-time.
Oracle's so called "Transparant Application Failover" (TAF) in read/write-transactions doesn't come for free as it requires programmatic support in the application.
Anyway, consult with your DBA about tnsames and check the Oracle documentation.

By now I would like to use "Transparant Application Failover" (TAF)
What programmatic support do You mean?

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 (3.2.5) uses direct JDBC calls (ServerLogon Modul, SecurityProxy etc.), CMP- and BMP-Beans to access the database.