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. &OHacgr;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]>