Failover doesn't work for Java clients, but works for SQL Plus

From: Andreas Sheriff <spamcontrol_at_iion.com>
Date: Tue, 13 Jun 2006 01:28:09 -0700
Message-ID: <lGujg.13358$KB.3194@fed1read08>

Oracle 10.2.0.2.0
RHEL4
2 Node rac

I can't seem to get failover to work for Java clients using jdbc:thin
(term?).

I'm usinig the connect descriptor:

  (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1523))
(LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = test.test.com) (FAILOVER_MODE = (TYPE = SELECT)
(METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ) )
Which is the same descriptor that I'm using in SQL*Plus:

test.test.com =
  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1523))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test.test.com)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )

    )
  )

SQL*Plus connects with failover, but Java does not. The manual states that the thin interface should be able to connect if you use the whole descriptor while connecting, but that doesn't seem to work.

Has anyone else experienced that and have come up with a solution?

Please don't tell me I have to use this crazy syntax:

http://download-west.oracle.com/docs/cd/B19306_01/rac.102/b14197/hafeats.htm#sthref453

-- 
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup 

Received on Tue Jun 13 2006 - 03:28:09 CDT