Re: Help connecting JDeveloper 3.0 to Oracle8i through JDBC

This may help..

Oracle thin doesn't talk with sql plus. It talks dietctly to the listener. Try using the instance name of the oracle database instead of a net service name.

you may also want to check and see that the driver package is pointed to by the default project file.
do that by the menu.. tools.. default project properties.. paths.. and add the library.

add the library by clicking on libraries, then pick your library or click on new.
if you click on new, you name the library, and add the paths to the classes, source and doc

Steven finkelman,
ideas llc.

Jacob wrote:

> Hi all.
>
> This may be a simple question to most of you, but anyway. I just got
> JDeveloper 3.0 and wanted to connect it to Oracle8i, running on another
> machine on the network. My own NT Workstation have the Oracle8i Client
> installed, and I have set up a Net Service Name for the server at TCP/IP
> address 192.168.1.1, port 1521, called "ORACLE8I.IKASTHS.DK". The Net
> Service Name is tested using Net8 Assistant, and there doesn't seem to be
> any problems here. I have also tested with SQL*Plus, and no problems here
> neither.
>
> I try to establish a connection by right-clicking on "Connections..." in
> JDeveloper, which brings up the Connections dialog. I now want to establish
> a connection to the server with either the JDBC Thin Driver or the OCI8 JDBC
> Driver. But none of them seems to work. Here's what happens:
>
> I choose "Existing TSN Names", and choose the one, that I created
> previously, "ORACLE8I.IKASTHS.DK", which is listed here.
>
> JDBC Thin: When I attempt to test the the connection, I get an error that
> starts with "Connection refused" and a lot of trace information, which
> somewhere says something about "ERRCODE=12505". I looked this error up in
> the documentation, which said something about "TNS:Listener could not
> resolve SID given in connect descriptor". But I don't know what to make of
> this error. As I mentioned before, everything works fine except in
> JDeveloper.
>
> OCI JDBC: Here I get a (maybe) more useful error. "No oci8jdbc (or something
> like that) in java.library.path". But what is "java.library.path", and where
> are the OCI JDBC drivers located? I assume it's all installed together with
> JDeveloper, since I checked an option saying "JDBC Drivers".
> "java.library.path" sounds like a Java classpath, but where do I set it up?
> In CLASSPATH or in some config file??
>
> Any help with any or both of these questions would be greatly appreciated!
>
> Thanks in advance!
>
> Jacob
>
> jacmads_at_hotmail.com
Received on Sat Nov 27 1999 - 02:28:28 CST