Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 13144 invoked from network); 14 Aug 2008 09:24:30 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 14 Aug 2008 09:24:29 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A437F914EB8; Thu, 14 Aug 2008 10:24:22 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05242-08; Thu, 14 Aug 2008 10:24:22 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1FD19914EFB; Thu, 14 Aug 2008 10:24:22 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 14 Aug 2008 10:22:27 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AC1DE913DB8 for ; Thu, 14 Aug 2008 10:22:27 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04912-03 for ; Thu, 14 Aug 2008 10:22:27 -0400 (EDT) Received: from rv-out-0708.google.com (rv-out-0708.google.com [209.85.198.245]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 52439913CE5 for ; Thu, 14 Aug 2008 10:22:25 -0400 (EDT) Received: by rv-out-0708.google.com with SMTP id b17so392186rvf.46 for ; Thu, 14 Aug 2008 07:22:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=P8PO9Ms45Bw9DXuwD20PvGSz4uuAmHAVCOKzotDaheo=; b=QXH6q5A8XD+Y58VvWd+oqpmBdJFVC4alsIy3SN6UUVeJCjQ2kzvRiHkh6CJeYB3lHp l5IxgyQYZfIWP2dTrFYyWPAziVSpVqBQMECIR7rOOISedUU4TzG706HY6UFSer6jl4I8 mZWite82JncDMYwHtV1o4bdtTgzKHKRHYi28k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=beycjBeLqQLexTXY4tj9hzvgvMBN1kTEkyo+VwWYlZAqsGbU4tx6k7LhF9H+RwGb9A 9Cd/OR85H1Yl6rqp/r4wL8rUTLF2t73MLhRCcYd7IfGRnU6f2zbevNKA1ybAVgoSYY5c UIa8xWratFV2U9COhIypiE97NIui1InZO8qoQ= Received: by 10.140.204.7 with SMTP id b7mr694292rvg.175.1218723745648; Thu, 14 Aug 2008 07:22:25 -0700 (PDT) Received: by 10.141.49.15 with HTTP; Thu, 14 Aug 2008 07:22:25 -0700 (PDT) Message-ID: <55f303590808140722r3d8e4400k4901c6e04d4c9e39@mail.gmail.com> Date: Thu, 14 Aug 2008 10:22:25 -0400 From: "Roman Podshivalov" To: JDunn@sefas.com Subject: Re: RAC failover and JDBC string Cc: oracle-l In-Reply-To: <2F802216565E44489600A03F763219A83E9A3D@mia.SEFASBRISTOL> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_128806_21277297.1218723745655" References: <2F802216565E44489600A03F763219A83E9A3D@mia.SEFASBRISTOL> X-archive-position: 10123 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: roman.podshivalov@gmail.com Precedence: normal Reply-to: roman.podshivalov@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_128806_21277297.1218723745655 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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? > > > > > > ------=_Part_128806_21277297.1218723745655 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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@sefas.com> 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?
 
 
 
 
 

------=_Part_128806_21277297.1218723745655-- -- http://www.freelists.org/webpage/oracle-l