Re: failover JDBC thin driver connection in 10.2 RAC

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 20 Aug 2006 15:34:07 -0700
Message-ID: <1156113246.803427@bubbleator.drizzle.com>

cbarak wrote:
> 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.

With 10gR2 I would recommend use FCF and not use TAF as TAF seems to be on its way to obsolesence.

http://download-west.oracle.com/docs/cd/B19306_01/rac.102/b14197/hafeats.htm#sthref455

Should get you where you want to go.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Aug 20 2006 - 17:34:07 CDT