Re: JDBC - No more data to read from socket

From: Phil Britton <PhilBritton_at_bigfoot.com>
Date: Wed, 27 Jan 1999 11:57:50 GMT
Message-ID: <36aefda7.95842323@pub.news.uk.psi.net>

On Tue, 26 Jan 1999 23:06:38 GMT, jlee_at_tyc.com wrote:

>Hi,
>
> I am using JDBC thin driver, jdk 1.17, Oracle 7.3.3.0.0., and Visual Cafe
>3.0. when the JAVA application idles for 10 - 15 minutes, I got "No more
>data to read from socket" error message from the Visual Cafe Debugger after I
>try to do something. e.g. clicking on search button.
>
> When I check the login status from Oracle Enterprise Manager, it is
>inactive.
>
> Any suggestion?
>

Do you have a timeout parameter set in sqlnet.ora on the server. This could be causing Oracle to kill the connection if there is now activity on a connection after, say, 10 minutes if you have set sqlnet.expiretime = 10 for example

HtH

Phil Received on Wed Jan 27 1999 - 05:57:50 CST