Re: failover JDBC thin driver connection in 10.2 RAC

Download Oracle's ons.jar and get it into your classpath.

Joe Weinstein at BEA Systems

cbarak wrote:
> 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 Wed Aug 23 2006 - 09:33:37 CDT