Re: failover JDBC thin driver connection in 10.2 RAC

I confirm, FCF is driver-independent while TAF is an OCI feature and can only be used with JDBC-OCI. FCF requires the application or the container to re-submit a getConnection() request upon RA node failure, which is a good JDBC coding practice -- while this happens transparently with TAF however, TAF is not integrated with the connection pool and certain features do not work as people would think. I cover in greater details FCF and compare with TAF in my book

Kuassi - blog http://db360.blogspot.com/

DA Morgan wrote:
> 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 Tue Aug 22 2006 - 14:00:22 CDT