Re: JDBC Thin: "No more data to read from socket"

Check on the server (alert.log)
This error generally means the server had some problems (listener, ORA-600 ORA-7445 ...) Mattias Arbin <Mattias.Arbin_at_Carmenta.se> writes:

> I have been using the JDBC thin client against Oracle 7.3.3 ( I
> have been told that the thin driver should be backward
> compatible) on Solaris and it has been working perfectly for
> months. After restarting the DB however, I get the error below.
> I have tried to restart both the server and my client machine but
> nothing works. Very frustrating, since it worked before!
> Does anybody know if this is a known bug and if it has some kind
> of solution?
> Thanks in advance.
> Mattias Arbin, Carmenta
>
> Server: Solaris, Oracle 7.3.3
> Client: NT 4.0, JDK1.2.2, JDBC Thin driver 8.1.6 (classes12.zip)
> (Have also tried JDK1.1.8 + classes111.zip)
>
>
> Error code: 0, SQL state: null, No more data to read from socket
> java.sql.SQLException: No more data to read from socket
> at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:419)
> at oracle.jdbc.ttc7.TTCInBuffer.getByte(TTCInBuffer.java:94)
> at oracle.jdbc.ttc7.TTIMsg.unmarshalSB1(TTIMsg.java:1085)
> at oracle.jdbc.ttc7.TTIdty.receive(TTIdty.java:228)
> at oracle.jdbc.ttc7.TTC7Protocol.connect(TTC7Protocol.java:1051)
> at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:162)
> at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:
> 103)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:148)
> at java.sql.DriverManager.getConnection(DriverManager.java:457)
> at java.sql.DriverManager.getConnection(DriverManager.java:137)
> at drc.test.OracleTest.main(OracleTest.java:18)
>
> --
> Mattias Arbin, Carmenta AB
> Box 31121, SE-400 32 Göteborg, SWEDEN
> Phone: +46 (0)31 7755706, Cellular: +46 (0)705 125868
> Fax: +46 31 246379, Email: Mattias.Arbin_at_carmenta.se
Received on Fri Aug 27 1999 - 13:57:43 CDT