Re: failover JDBC thin driver connection in 10.2 RAC

thanks everyone for their inputs.

I've created an oracle data source in my java program and enabled caching and FCF -
ods.setConnectionCachingEnabled(True);
ods.setFastConnectionFailoverEnabled(True);

however when I tried executing the program, I kept gettting NoClassDefFoundError: oracle/ons/ONSException. Are there any other classes I have to include other than the following -

import java.sql.*;
import oracle.jdbc.driver.*;
import oracle.jdbc.pool.*;

Exception in thread "main" java.lang.NoClassDefFoundError: oracle/ons/ONSException

        at
oracle.jdbc.pool.OracleConnectionCacheManager.createCache(OracleConnectionCacheManager.java:261)

        at
oracle.jdbc.pool.OracleConnectionCacheManager.createCache(OracleConnectionCacheManager.java:167)

        at
oracle.jdbc.pool.OracleDataSource.cacheInitialize(OracleDataSource.java:427)

        at
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:402)

        at
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:189)

        at
oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)

        at test1.main(test1.java:20)

thanks.

kuassi.mensah_at_gmail.com wrote:
> 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 - 18:53:36 CDT