[Proxool-developer] Proxool hang when there's a connection problem to database

[Ivan Y. <iv...@gm...>]

I'm using proxool to connect to an Oracle DB.

I'm testing on how long proxool will pass the control back to the
application when there's a network problem. Here's the proxool
confirguration.

jdbc-0.proxool.test-before-use=true
jdbc-0.proxool.house-keeping-sleep-time=60000
jdbc-0.proxool.house-keeping-test-sql=select sysdate from dual
jdbc-0.proxool.maximum-connection-count=3
jdbc-0.proxool.minimum-connection-count=1
jdbc-0.proxool.maximum-connection-lifetime=60000
jdbc-0.proxool.simultaneous-build-throttle=5
jdbc-0.proxool.recently-started-threshold=40000
jdbc-0.proxool.overload-without-refusal-lifetime=50000
jdbc-0.proxool.maximum-active-time=20000
jdbc-0.proxool.verbose=false
jdbc-0.proxool.trace=false
jdbc-0.proxool.fatal-sql-exception=Fatal error
jdbc-0.proxool.prototype-count=1
jdbc-0.proxool.statistics-log-level=DEBUG
jdbc-0.proxool.statistics=1m,15m

I've start a simple program with a single thread getting connection from the
pool, execute a query and close the connection within an infinite loop. Then
I try to disable the connection from the server host to the database, the
application hang until all connection are consumed and the Oracle driver
throw the "The Network Adaptor could not establish the connection ... "
exception. It takes more than 5 minutes

Seems that the housekeep will not kill the connection and pass the control
back to the application until the network connection timeout occur.I wonder
if there's any way for me to solve this problem, why the housekeeper not
working? It's expected the housekeep will kill the connection since
maximum-active-time is 20 seconds only. Same problem occur when i disconnect
the DB before getting the connection from pool using the getConnection()
method or before executing the query.

Thanks for your help.