failover JDBC thin driver connection in 10.2 RAC

From: cbarak <charlinbarak_at_gmail.com>
Date: 20 Aug 2006 08:51:12 -0700
Message-ID: <1156089072.636327.21790@h48g2000cwc.googlegroups.com>

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. Received on Sun Aug 20 2006 - 10:51:12 CDT