Re: Oracle 9i RAC JDBC listener connection load balancing

Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<qft7a0tve6e1ulapd5d71n844b39p24588_at_4ax.com>...
> On 13 May 2004 13:28:57 -0700, mexilent_at_hushmail.com (robert lojek)
> wrote:
>
> >We're trying to load balance thin-client JDBC connections to oracle 9i
> >RAC nodes. The main objective is actually redundancy, i.e., if there's
> >an abnormal termination of a connection due to RAC node failure and
> >the load balancer detects this (within x seconds), send the retried
> >connection to a different RAC node.
> >
> >Does anyone have experience with hardware loadbalancers tackling this
> >kind of scenario, or know of a good resource to investigate this
> >further? We're going to be doing some experimenting with Cisco
> >LocalDirectors, and I'll report whatever we find, but I wanted to know
> >if anyone else has experience dealing with this kind of issue & how
> >you addressed it.
> >
> >Best,
> >
> >Robert Lojek
>
>
> 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)

the OP is using jdbc-thin, which does not support this. (i.e. is configured with hostname, listener port and oracle sid as opposed to a tns alias)
I don't understand why every java developer is so keen on using that thin driver, only to find out that it does not have the functionality that one wants.

simply switching to oci driver solves all those issues, and it is usually a one-line change to the application.

Karsten Received on Fri May 14 2004 - 08:41:16 CDT