Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with Java JDBC connecting to Oracle8
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