Is your jdbc connection routed thru a firewall or a gateway server? If yes,
then it might be that the firewall or the gateway closes the connection if
it has been idle for a specified time. The fix: check the settings on the
firewall/gateway or add sqlnet.expire_time = 10 to your sqlnet.ora file on
the listener side. It makes the listener to refresh the connection in every
10 minutes.
--
Heikki
http://www.heikkisiltala.com
"Henry" <hxzhang_at_binary-solutions.net> kirjoitti viestissä
news:VwTb8.2380$Bw4.1531917_at_news1.telusplanet.net...
> This is very wierd to me but I don't know if it has something to do with
> Personal Edition of Oracle 8i, installed on Mandrake 2.4.8.
>
> I started server by "lsnrctl start". then everything is ok. I tried jdbc
> thin connection from outside LAN, and it works fine. However, I must keep
> that jdbc program running. If i stopped that jdbc program for a little
> while, the network connection will fail.
>
> java.sql.SQLException: Io exception: The Network Adapter could not
establish
> the
> connection at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
>
> I checked the listener log, everything is OK, except that the client side
> get the above message. When I am trying jdbc connection from inside LAN,
I
> never have that problem. does anybody know why?
>
>
Received on Sun Feb 17 2002 - 13:41:04 CST
