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? We use db connection pool that keeps the connections alive. ¿has this connection living time anything to do? Thanks in advance -- Carlos J. Ramos -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
