[jira] Closed: (DBCP-296) Db connection issue due to firewall timeout

["Mark Thomas (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DBCP-296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mark Thomas closed DBCP-296.
----------------------------

    Resolution: Invalid

Jira is not a support forum. Please use the users list.

> Db connection issue due to firewall timeout
> -------------------------------------------
>
>                 Key: DBCP-296
>                 URL: https://issues.apache.org/jira/browse/DBCP-296
>             Project: Commons Dbcp
>          Issue Type: Bug
>         Environment: RHEL,
> Tomcat 6.0.18
> Java(TM) SE Runtime Environment (build 1.6.0_13-b03)
>            Reporter: Max W
>
> Hello,
> We use a db datasource for one of our applications.
> The issue is that there is a firewall between tomcat server & db server (ORACLE 10g), that cuts pool connections after 1 hour of inactivity (it does not send anything, no FIN, no RST, it just drop packets), and the server goes wrong because of it reaches the maxActive value.
> We've tried several configuration using :
> validationQuery
> testOnBorrow
> testOnReturn
> testWhileIdle
> timeBetweenEvictionRunsMillis
> numTestsPerEvictionRun
> minEvictableIdleTimeMillis
> But that does not solve the problem (Moreover, I am not sure of the values I use for these params !)
> Could you please give me some advices about the way I have to configure this to get it working ?
> Best Regards.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.