Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Socket errors in Oracle JDBC type 4 (still not answered)
We also encountered the same problem as you have with Oralce server ver 7.3.2 but the problem just gone while we connected to Oracle server ver 7.2.3 If you can somehow solve the problem with 7.3.2 server please kindly let me know.
Kirk Woerner wrote:
> We are using Oracles "Thin client" Type 4 drivers We have
>
> Server Side, SGI
> ------------
> Irix 6.2
> Oracle 7.3.2
> Listener version 2.3.2.1
>
> Client Side, SGI
> Irix 6.2 (and/or Solaris 2.5)
> JDK 1.1.3
> Oracle Type 4 driver 7.3.3.1.3
>
> The problem is, we start up an application which holds connections
> open
> to the server and after awhile (15 to 30 minutes) of serving up fine,
> we
> get the following exception.
>
> java.sql.SQLException: No more data to read from socket
> at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:382)
> at oracle.jdbc.ttc7.TTCInBuffer.getByte(TTCInBuffer.java:94)
> at oracle.jdbc.ttc7.TTIMsg.unmarshalSB1(TTIMsg.java:929)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:442)
> at
> oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1174)
> at
> oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Protocol.java:575)
> at
> oracle.jdb
> .driver.OracleStatement.doExecuteQuery(OracleStatement.java:1094)
> at
> oracle.jdb
> .driver.OracleStatement.doExecuteOracleState(ment.java:1135)
> at
> oracle.jdb
> .driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
>
> atgetInventory(
> oracle.jdbc.driver.Orac
> ePreparedStatement.executeQuery(OraclePreparedStatement.java:57)
> at II.Service.Reward.RewardImpl.RewardImpl.java:235)
>
> Any ideas?
Received on Tue Aug 26 1997 - 00:00:00 CDT