Hello Community,
I have a weird issue, which I am not able to figure it out and needed
some help. I am a Web Administrator and in my organization we use Tomcat +
CXF to run our commerce services.
We are running on Tomcat-6.0.32 and jdk1.6.0_24, anyways we have recently
started to see issues with our connection pool and from our monitoring
tools its evident that we are running out of connections. Now I have read
some manuals on Apache Tomcat Page to use below three settings to fail
gracefully and to Log those sessions which are either causing connection
leak or abandoned
removeAbandoned - set to true if we want to detect leaked connections
removeAbandonedTimeout
logAbandoned="true"
But unfortunately even after having configured those above three settings,
I still see some sessions just hanging in and not releasing the connection
and I need help in understanding what I am doing wrong.
My DS cnfiguration
<Resource name="jdbc/XXXXXDataSource" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="XXXXXXXXXXX"
username="XXXXXX" password="XXXXXX" initialSize="1" maxActive="10"
minIdle="1" maxIdle="1"
connectionCachingEnabled="true" fastConnectionFailoverEnabled="true"
connectionCacheProperties="{MinLimit=1, MaxLimit=20, InitialLimit=1,
oracle.net.ns.SQLnetDef.TCP_CONNTIMEOUT_STR=3000}"
ONSConfiguration="nodes=XXXXX"
validationQuery="SELECT 1 from DUAL"
removeAbandoned="true"
removeAbandonedTimeout="30"
logAbandoned="true"
maxWait="-1"/>
Thanks
Pradeep
