JDBC errors with Oracle

From: <ntolia_at_my-deja.com>
Date: Mon, 24 Jan 2000 05:43:11 GMT
Message-ID: <86gopd$pco$1@nnrp1.deja.com>

Hi,

I am trying to interface Java with Oracle 8.0.3. I used the Oracle 8 JDBC Thin drivers from Technet (Version 8.0.4.0.6 for NT 4.0).

However on trying to connect, I keep on getting a SQLException which says -- "java.sql.SQLException: No more data to read from socket".

I know for a fact that my usernames are valid (though using invalid usernames brings up the same error) and that the DB does _have_ data. I am also guessing that my connect string is correct as I can use SQL*Plus to access the database using it and insert/delete/update data. Does anyone have any idea why I am getting this error ? All help would be appreciated. Have included my JDBC calls below

I first do a

DriverManager.registerDriver (new
oracle.jdbc.driver.OracleDriver() );

and then the call to the connection is

con = DriverManager.getConnection (
"jdbc:oracle:thin:@"+CONNECT_STRING,"username" ,"password");

where
CONNECT_STRING =
(DESCRIPTION=(ADDRESS=(HOST=my.host.name)(PROTOCOL=tcp)(PORT=1521))(CONN ECT_DATA=(SID=ORCL))) I also did try jdbc:oracle:thin:@<hostname>:1521:<database sid> but got the same error.

Thanks,
Niraj.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jan 23 2000 - 23:43:11 CST