You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "Max W (JIRA)" <ji...@apache.org> on 2009/07/07 10:34:15 UTC
[jira] Created: (DBCP-296) Db connection issue due to firewall
timeout
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.
[jira] Closed: (DBCP-296) Db connection issue due to firewall
timeout
Posted by "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.