Re: OCI9 driver

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 20 Sep 2002 01:16:36 +0200
Message-ID: <gkmkouoos9dtbkneqvssu1t0kgpr51usra@4ax.com>

On 19 Sep 2002 13:23:04 -0700, rvasisht_at_scsnet.csc.com (Rajesh Vasisht) wrote:

>I am getting an "Invalid URL" error when I try to connect to an Oracle
>9.2 database via the OCI9 driver. Both my client and the backend
>database are running HP-UX 11. I have loaded the Oracle9i client on my
>client machine and set CLASSPATH to include the classes12.jar. I've
>also set the LD_LIBRARY_PATH environment variable to point to the
>libocijdbc9.a library. My connect string looks like:
>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??

Check the syntax against the Oracle documentation. IIRC the @ is not part of the correct syntax.
Actually, preferably you should do that before posting.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Sep 19 2002 - 18:16:36 CDT