Re: RAC failover and JDBC string
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: "Dan Norris" <dannorris@xxxxxxxxxxxxx>
- Date: Tue, 19 Aug 2008 09:41:13 -0400
To refresh my memory, I did some research too. Starting from 10.2 thin JDBC
driver could utilize FAN events and perform Fast Connection Failover
according to the documentation:
http://download.oracle.com/docs/cd/B28359_01/rac.111/b28254/hafeats.htm#BABFCFHA
It's not TAF, and reading sessions will be disconnected, but other features
look very similar, especially for app server/connection pool/JDBC type
of setups . I personally never tested or tried this feature. Any early
adopters ?
thanks
--romas
On 8/19/08, Dan Norris <dannorris@xxxxxxxxxxxxx> wrote:
>
> You're not mistaken (at least according to the docs):
>
> 10.2:
>
> http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/ocitaf.htm#BABGIDEE
> 11.1:
>
> http://download.oracle.com/docs/cd/B28359_01/java.111/b31224/ocitaf.htm#BABGIDEE
> ML:
> 297490.1 (which reprints the 10.2 docs)
>
> Roman Podshivalov wrote:
>
> Hi,
>
> If I'm not mistaken to get an advantage of TAF with JDBC you need to use
> JDBC thick (OCI) driver and connection string should be either properly
> configured TNS alias or fully qualified TNS entry (TAF aware) specified in
> JDBC connection string. Thin driver wasn't TAF aware last time I've checked,
> but it could have changed since then.
>
> --romas
>
>
> On 8/14/08, John Dunn <JDunn@xxxxxxxxx> wrote:
>>
>> I need to understand how RAC handles hostnames in JDBC connection
>> strings.
>>
>> If I have an application that uses a JDBC connection string(that contains
>> a hostname) to connect to the Oracle database, what happens if there is a
>> failover to another server in the RAC cluster?
>>
>>
>>
>>
>>
>>
>
>
Other related posts:
