JDBC connection and RAC database

--_000_F73D272CB84DC34595AA137A791515506160E59FEXMBXVS2campusm_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I would like to configure a jdbc connection to access an Oracle RAC databas=
e.
Actually my jdbc connection has this format:
jdbc:oracle:thin@server:port:sid

I have no problem to connect to the database this way.

I tried to change this for:
jdbc:oracle:thin:@(DESCRIPTION=3D(LOAD_BALANCE=3Don)
(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dhost1) (PORT=3D1521))
(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dhost2) (PORT=3D1521))
(CONNECT_DATA=3D(SERVICE_NAME=3Dservice)))

But with this format I have an error when I use the button Test Connection:
Invald Oracle Url specify
SQL Status: 99999
Error code: 17067
Invalid Oracle URL specified

Is it possible to configure a jdbc connection to point to Oracle RAC databa=
se or it is not supported with OpenOffice?

Thanks!

M=E9lanie Bastarache
Administrateur de base de donn=E9es / Databases Administrator
MOMENTUM TECHNOLOGIES INC.
Vos experts en solutions Oracle  et Java
At
McGill University,
Information Systems Resources (ISR), DBA Team
688 Sherbrooke St W. Suite 500,
Montreal QC  H3A 3R1
Tel: 514-398-5023, ext 09558


--_000_F73D272CB84DC34595AA137A791515506160E59FEXMBXVS2campusm_--