bug tracking software
Aug 21, 2004 | Home > Bugzero > FAQs > Errors

Oracle SQLException: No more data to read from socket

java.sql.SQLException: No more data to read from socket
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
        at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)
        at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:375)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2877)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)

This error most likely occurs in applications that use a database connections pool. When the application checked out a connection that has been timed out or has been staled, and used it to connect to the database, this error occurs.

You may need start your Oracle database server as well as your Java application. In a better designed system, however, the staled connection should be cleared out and a new connection should be establised automatically.

* Reference brought to you by Bugzero, it's more than just bug tracking software!