Help connecting JDeveloper 3.0 to Oracle8i through JDBC

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 Thu Nov 25 1999 - 04:19:27 CST