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)
Try to look in sqlnet.log file on the server side for more detailed explanation of the problem. You'll find there the TNS error code and a corresponding error message. Basically this means you lose the connection with the listener port (should be 1526 or close). To verify that this is the case, do "netstat -na | grep 1526" on the server before and after you get the error.
Thanks,
Boris Plotkin.
Kirk Woerner <kirk_at_riddler.com> wrote in article
<33FDDB35.54D6_at_riddler.com>...
> 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.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1094)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteOracleState(ment.java:1135)
> at
>
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1170)
> atgetInventory(
>
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:57)
> at II.Service.Reward.RewardImpl.RewardImpl.java:235)
>
> Any ideas?
>
Received on Fri Aug 22 1997 - 00:00:00 CDT
![]() |
![]() |