We are experiencing the same issue. It all worked fine until we put the firewall in. This appears to be a bug in the firewalls or the way java or oracle handle them. All you can do is make sure it recreates the connection. The way we had to test it was to create a statement as checking to see if the connection is null and using the isClosed() method did not pick it up.
Stuart -----Original Message----- From: Reynir H�bner [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 11:45 To: Tomcat Users List Subject: RE: Disconnection from Oracle. 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
