Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with Java JDBC connecting to Oracle8

Re: Problem with Java JDBC connecting to Oracle8

From: RL Jameson <rjameson_at_io.com>
Date: Fri, 13 Aug 1999 14:37:57 -0500
Message-ID: <Pine.LNX.4.10.9908131432370.21364-100000@fnord.io.com>


Hello,

I'm using Classes12.zip which contains the Oracle libs ( class files) for connecting using the thin client. I'm connecting to a remote server running version 8.0.3.0.0 Enterprise Edition 60 day trial version of Oracle.

regards,

Randall Jameson
Jameson Software Dev. Lab. Inc.
email: rjameson_at_io.com
web : www.io.com/~rjameson

On Fri, 13 Aug 1999, TurkBear wrote:

>
> Please provide some additional info:
>
> What version of Oracle are you attempting to connect to?
>
> Is the Database on the same server as the application ?
>
> Which java libraries did you include in your app/project ?
>
> Thanks, maybe someone can help when the info is posted...
>
>
>
> RL Jameson <rjameson_at_io.com> wrote:
>
> >
> >I'm having trouble connecting to a server running Java JDK 1.2.2
> >with Oracl'es Java driver, Classes12.zip. This driver was freshly
> >download from Oracles Web Site. I get an exception,
> > End of TNS data channel
> >
> >Here is the code fragment that causes the exception:
> >
> > // The driver to load
> > static final String driver_class = "oracle.jdbc.driver.OracleDriver";
> >
> > // The connect string
> > static final String connect_string =
> > //<host>:<port>:<sid>
> > "jdbc:oracle:thin:@myServer:1521:myDataBase";
> >
> > // Load the JDBC driver
> > Class.forName (driver_class);
> >
> > // Connect to the databse
> > conn = DriverManager.getConnection (connect_string, "myUserId",
> > "myPassWord");
> >
> > // ^^^^^ exception caused by this connect.
> >
> >
> >Here's the exception text:
> >
> >java.sql.SQLException: End of TNS data channel
> > at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:406)
> > at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:169)
> > at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:231)
> > at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:208)
> > at java.sql.DriverManager.getConnection(DriverManager.java:457)
> > at java.sql.DriverManager.getConnection(DriverManager.java:137)
> >
> >
> >Does anyone have any pointers.
> >
> >regards,
> >
> >Randall Jameson
> >Jameson Software Dev. Lab. Inc.
> >email: rjameson_at_io.com
> >web : www.io.com/~rjameson
> >
>
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
>
>
Received on Fri Aug 13 1999 - 14:37:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US