Re: Help connecting JDeveloper 3.0 to Oracle8i through JDBC

Does it matter where the database is located since the connection is done TCP/IP? Could JDeveloper be located on a Win95/98/NT box and the server on Linux?

--Hal.

Swahanaga <sfinkelman_at_cncdsl.com> wrote in message news:383F94E4.502D1E3B_at_cncdsl.com...
> more thoughts on the subject...
>
> you may want to watch the server and tail out the listener.log file to see
what
> the listener is recieving.
> This may give you a clue as to what the connection is asking for.
>
> 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 Sun Nov 28 1999 - 00:12:23 CET