Re: jdbc thin and TAF connections

From: Igor Racic <igor.racic_at_gmail.com>
Date: Wed, 20 Apr 2011 20:16:05 +0200
Message-ID: <BANLkTiksyhntCtc14BGy33v_s809F0=JFw_at_mail.gmail.com>



Hi,

As guys already said, TAF won't work using thin driver.

For thin, FCF is documented that should work. I haven't tried it yet, so any feedback about experiences would be welcome...

Thank you and regards,
Igor

2011/4/20 John Scoles <scoles_at_pythian.com>

> Seems JDBC uses TTC (Two Task connection) rather that OCI so you cannot use
> any of the nifty OCI stuff. Look like you are back in the dark ages of
> Oracle 7 when using this client.
>
> Cheers
> John
>
>
> On 20/04/2011 12:00 PM, Herring Dave - dherri wrote:
> Right, I don't have a good place to test this. I was figuring a check of
> FAILOVER* columns in the GV$SESSION view would be good enough verification
> on what is getting set. I also validated with using sqlplus with a full
> connect string:
>
>> sqlplus<user>/<pass>_at_'(DESCRIPTION...(FAILOVER = ON)...(FAILOVER_MODE =
>> (TYPE = SELECT) (METHOD = BASIC))'
>>
>> that indeed FAILOVER* columns were set properly in GV$SESSION, so I
>> hopefully eliminated any other problem other than jdbc/10g combo.
>>
>> DAVID HERRING
>> DBA
>> Acxiom Corporation
>> EML dave.herring_at_acxiom.com
>> TEL 630.944.4762
>> MBL 630.430.5988
>> 1501 Opus Pl, Downers Grove, IL 60515, USA
>> WWW.ACXIOM.COM
>>
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 20 2011 - 13:16:05 CDT

Original text of this message