Re: Oracle 9i RAC JDBC listener connection load balancing

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Fri, 14 May 2004 21:34:19 -0700
Message-ID: <40A59DCB.9070606@bea.com>

Daniel Morgan wrote:

> Matt wrote:
>

>> As far as I know TAF doesn't support thin JDBC connections....
>>
>>
>>> Oracle Net comes with Transparent Application Failover and Load
>>> balancing, suitable for RAC. Exactly what you need!
>>> Please read those manuals prior to resorting to your own 'solution'
>>> (which won't be supported by Oracle)

>
> Then you don't know a lot.
>
> TAF is supported by JDBC ... just not by the thin client.
>
> BTW: The TAF demo created by Oracle is built using JDeveloper. How
> do you think it connects to the database?
>
> For anyone wanting the TAF code ... it is available from the home
> page of the Puget Sound Oracle Users Group (http://www.psoug.org).

Actually, as of the 10g thin driver, there is some support for TAF. Beware that TAF doesn't really support JDBC... In-progress XA transactions do not failover, certain queries may fail, and package state does not fail over so prepared statements may become defunct... All in all TAF isn't, at least for JDBC. It's best at read-only clients.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=97926.1&p_showHeader=1&p_showHelp=1#TAFSEL Received on Fri May 14 2004 - 23:34:19 CDT