Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: OCI9 driver

Re: OCI9 driver

From: Candido Dessanti <termy_at_blunet.it>
Date: Fri, 20 Sep 2002 14:27:56 +0200
Message-ID: <3D8B144C.1020107@blunet.it>

> conn = DriverManager.getConnection("jdbc:oracle:oci9:@ORASID", dbUser,
> dbPass);
>
> ORASID is defined on the client's tnsnames.ora file. But I'm still
> getting that "Invalid URL" exception. Any ideas??

try putting the complete string instead the alias in this way

conn =
DriverManager.getConnection("jdbc:oracle:oci9:@(description=(address=(host=<you host>)(protocol=tcp)(port=<your port>))(connect_data=(sid=<your database sid>)))", dbUser,dbPass); Received on Fri Sep 20 2002 - 07:27:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US