We use persistant connections. It does it to us even so. It is more likely that the firewall has an idle time or a max timeout for a connection on the udp port 1521 or whatever you have set it to run on.
-----Original Message----- From: Skondras P. [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 12:10 To: Tomcat Users List Subject: Re: Disconnection from Oracle. Carlos Javier Ramos wrote: > We are having a problem with a jdbc connection object between tomcat > (linux 2.4.18 - tomcat 3.3.1) and an oracle server (HP-UX 11i Oracle > 8.1. The 2 machines are separated by a firewall which was > configured to allow access to the oracle server from the tomcat server > only. > > We can see that the conexion pool gets disconnected each 1 hour and 1 > minute (+- 3660 s). > > Once it is disconnected, the application then freezes any attempts to > login/manage your account or do activities which need database > connection. > > Tomcat still works fine, any servlets which do not need database > connection works. > > We have developed a Sentry bash script able to check if the connection > pool is broken and then restart tomcat createing a new one. > > We suspect that it is not a problem of linux or hp kernel, neither from > Oracle, because if we made: > > $ telnet databasehost 1528 > > we did not get disconnected... > > As we have discovered isClosed is unable to detect this problem. The > exception throwed when this problem appears is an IOexception, not an > SQL exception. > > Which is the way to detect when a connection is closed but the > isClosed() function does not recognize this? > Execute a query that you now it should work e.g select sysdate from dual and if you get an Exception reopen the Connection > > We use db connection pool that keeps the connections alive. �has this > connection living time anything to do? > Perhaps the Connection pool has an attribute disconnect if idle for more that some time. > > Thanks in advance > > -- > Carlos J. Ramos > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
