Re: Problem with Java JDBC connecting to Oracle8

This app is being developed with Sun's Java JDK 1.2.2.

In other words I wrote the application in Java and I'm using JDBC ( the Java clone of ODBC) and Oracle thin client to try and connect to the Oracle8 server running on another box. My guess is I'm having this problem because we have an eval copy of the server.

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:

>
> Don't you just hate it when an answer to a question provokes more questions ?
> Anyway, I should have also asked what you are developing the app with...?
>
> Sorry...
>
>
>
>
> RL Jameson <rjameson_at_io.com> wrote:
>
> >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 ==-----
> >>
> >>
>
>
>
> -----------== 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 - 16:46:43 CDT