This content has been marked as final.
Show 3 replies
-
1. Re: Oracle database cluster
schmidts Feb 4, 2004 3:02 PM (in response to sheckler)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. -
2. Re: Oracle database cluster
sheckler Feb 5, 2004 9:23 AM (in response to 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! -
3. Re: Oracle database cluster
sheckler Aug 20, 2004 7:24 AM (in response to 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.