tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Reynir Hübner <rey...@hugsmidjan.is>
Subject RE: Disconnection from Oracle.
Date Mon, 13 May 2002 10:45:13 GMT
sounds like a bug in your connection pooling software..

hope it helps
-reynir


> -----Original Message-----
> From: Carlos Javier Ramos [mailto:cjramos@genasys.es]
> 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:tomcat-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: 
> <mailto:tomcat-user-help@jakarta.apache.org>
> 
> 

--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message