Re: Problem with Java JDBC connecting to Oracle8

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:34:29 CDT