I got this problem with the Thin driver, too. Try using the OCI-8 driver
instead (assuming your drivers are in the Oracle download, classes111.zip).
Just change "thin" to "oci8" in your getConnection( ) parameter.
<ntolia_at_my-deja.com> wrote in message news:86gopd$pco$1_at_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 Mon Jan 24 2000 - 21:09:58 CST
