commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <>
Subject RE : dbcp exception on dead network
Date Tue, 16 Jan 2007 18:45:48 GMT
Hi Matteo,

I've been having the same issue. Recently Oracle Driver 10.2+ let you set oracle.jdbc.ReadTimeout
as a connectionProperty. You must absolutely use the thin driver for this to work. (I tested
successfully with

This solves the problem for a dead network and pooled connection with oracle thin driver.

Pierre Fortin 

-----Message d'origine-----
De : Campanella Matteo [] 
Envoyé : 19 décembre 2006 15:45
À : ''
Objet : dbcp exception on dead network

Hello, I would like to use DBCP in an enterprise application I am working
What I need though is an exception to be raised in case I get connectivity
problem with the database, as for example if my oracle get disconnected from
the network.

I prepared a testbed like this: I run my application for a while, getting
the pool populated of connections and then I use iptables on the server
running tomcat to reject all incoming and outgoing traffic from/to the db -
at this point I call a servlet that uses a connection from the pool to do
query; using the basic setting of dbcp, the query hangs indefinitely, while
I would need a behaviour so that after a timeout an exception is reported to
the application.

Is this possible with dbcp?

thanks in advance for the help
best regards

To unsubscribe, e-mail:
For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message