failover JDBC thin driver connection in 10.2 RAC

Giganews Newsgroups
Subject: failover JDBC thin driver connection in 10.2 RAC
Posted by:  cbarak (charlinbar…@gmail.com)
Date: 20 Aug 2006

I have problem failing over JDBC (thin driver) connection using TAF:

Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
dhp1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST =
dhp2-vip)(PORT =1521)) (ADDRESS = (PROTOCOL = TCP)(HOST =
dhp3-vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER =
DEDICATED) (SERVICE_NAME = ypapps) (FAILOVER_MODE = (TYPE = SELECT)
(METHOD = BASIC) (RETRIES = 180) (DELAY = 5))))","scott","tiger");

>From the many threads I have read, some folks were able to use TAF for
JDBC thin client connections in 10gr2. Are there any specific
configuration I have to set up for JDBC thin client to make failover
transparent?

I have also read from Oracle manuals that Fast Connection Failover is
the preferred method for jdbc connection. How do I turn on FCF - ie
where do I set FastConnectionFailoverEnabled=true? For now, I'm just
running a simple java program on one of the RAC nodes that connects to
the database via jdbc thin driver and does a query on schema objects.
Do I specify FastConnectionFailoverEnabled=true in some Oracle
configuration file or in my .java program?

Thanks.

Replies