Re: Problem with Java JDBC connecting to Oracle8

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:27:31 CDT