sounds like a bug in your connection pooling software.. hope it helps -reynir
> -----Original Message----- > From: Carlos Javier Ramos [mailto:[EMAIL PROTECTED]] > Sent: 13. ma� 2002 09:27 > To: Tomcat Users List > Subject: Disconnection from Oracle. > > > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
