commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ajay Warrier (JIRA)" <j...@apache.org>
Subject [jira] Created: (DBCP-287) Socket Connection Timeout Fix for Connection Pool management
Date Mon, 06 Apr 2009 20:27:12 GMT
Socket Connection Timeout Fix for Connection Pool management
------------------------------------------------------------

                 Key: DBCP-287
                 URL: https://issues.apache.org/jira/browse/DBCP-287
             Project: Commons Dbcp
          Issue Type: Task
         Environment: JDK 1.5 on Linux Tomcat 5.5.23 with DBCP
            Reporter: Ajay Warrier


I have an apache tomcat server configured in the Production with DBCP Connection Pool parameters
configured to talk to the Database.
The Application war files looks at the datasource that is setup in the context.xml to connect
to the DB

Now the issue is....There is a firewall between the Tomcat Server and the DB. and the firewall
is programmed to timeout and disconnect any existing
sockets after an hour of inactivity. When this happens , and a new connection is tried from
the Tomcat Server to the DB, it fails as TOmcat still things that 
the connection is active and tries to make an attempt on this Socket timed out connection
and then it eventually times out.
Here is a snippet from my context.xml
<Resource name="jdbc/TESTDB" auth="Container" type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@SERVER_NAME:1521:TEST_DB_SID" username="TEST1" password="TEST1" maxActive="200"
maxIdle="10" maxWait="10000" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>

Can anyone help me resolve this issue? ..

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


Mime
View raw message