Re: Help with JDBC connection to Oracle RDB database...
From: <davide_speed_at_davidebianchi.net>
Date: 20 May 2002 09:40:23 GMT
Message-ID: <acaga7$o85rm$3_at_ID-18487.news.dfncis.de>
> username=devdb
> password=devpass
Date: 20 May 2002 09:40:23 GMT
Message-ID: <acaga7$o85rm$3_at_ID-18487.news.dfncis.de>
In comp.lang.java.databases bob brown <bobrown_at_start.com.au> wrote:
> database=jdbc:oracle:oci8:
>_at_(DESCRIPTION=(ADDRESS_LIST=(ADDRESS= >(PROTOCOL=TCP)(PORT=1527)(HOST=aotcsrv)))(CONNECT_DATA=(SID=siddev)))
> username=devdb
> password=devpass
If you use the oci8 driver, you should give just the reference of the already-configured SID of the database, the OCI driver will look in the client-installation of Oracle in the machine and use those informations to connect. Otherwise, use the thin driver.
Anyway, your dbUrl is wrong. See the documentation of Oracle about how to form a correct url.
Davide Received on Mon May 20 2002 - 11:40:23 CEST