Re: SQLException: no more data from socket

From: Johan Riise <d60690_at_wessel.be.statoil.no>
Date: 18 Mar 1999 11:11:25 GMT
Message-ID: <D60690.99Mar18121125@wessel.be.statoil.no>

>[Fri Mar 12 12:17:23 CST 1999] SQLException java.sql.SQLException: No
more data to read from socket

this might be the same problem i stumbled into. it looks like the exception is thrown exactly SQLNET.EXPIRE_TIME minutes after connection, regardless of the connection being used or not.

the SQLNET.EXPIRE_TIME parameter is found in the file sqlnet.ora on the server, not the workstation. on my site it was 5 minutes.

there are good reasons to keep this value low. other sqlnet-applications will not fail after the specified number of minutes, even if the application is just sitting there doing nothing over the connection. i belive there is a bug in the oracle jdbc thin drivers.

--
Johan Ur Riise
riise_at_bgnett.no Received on Thu Mar 18 1999 - 05:11:25 CST