Re: Contacting an Oracle NameServer using thin driver

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 6 Feb 2003 11:40:38 -0800
Message-ID: <92eeeff0.0302061140.1432a4f1@posting.google.com>

gvdinesh_at_lycos.com (Dinesh Varadharajan) wrote in message news:<4732cc2d.0302052008.630f4f21_at_posting.google.com>...
> Hi
>
> Can a JDBC application contact oracle database using oracle name
> server, instead of contacting the oracle database directly?
> Further clarifying the scenario, instead of the db url,
> sqlj.url=jdbc:oracle:thin:@databasemachinename:1521:dbinstance.
> can I use sqlj.url=jdbc:oracle:thin:@nameservername:port .
>
> Thanks
> Dinesh

> sqlj.url=jdbc:oracle:thin:@databasemachinename:1521:dbinstance
This will work with JDBC thin driver.

> can I use sqlj.url=jdbc:oracle:thin:@nameservername:port
This will not.

JDBC thin driver requires TCP protocol to connect to the database and the url *must* be in the form of HOST:PORT:SID. Since it is a pure java driver, it does not require Oracle middleware (net8/9).

In order to use Oracle's middleware (net8/9), you should use JDBC oci native driver.

Regards
/Rauf Sarwar Received on Thu Feb 06 2003 - 13:40:38 CST