Hi Users, im getting the connection pool issue.
*Unable to fetch a connection in xx seconds, none available[size:xxx; busy:xxx; idle:xx; lastwait:xxxx]. * *And Idle count is incresing more than the Maxidle connections.* *Here is the server.xml configured file,* > > <Resource name="@scc.datasource.name@" auth="Container" > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > type="javax.sql.DataSource" maxActive="100" > minIdle="10" maxIdle="30" > maxWait="10000" username="@scc.datasource.username@" > password="@scc.datasource.password@" > driverClassName="@scc.datasource.driver@" > url="@scc.datasource.driverurl@" logAbandoned="true" > validationQuery="SELECT 1" > removeAbandoned="true" > testOnBorrow="true" > testWhileIdle="true" > timeBetweenEvictionRunsMillis="10000" > minEvictableIdleTimeMillis="180000" > removeAbandonedTimeout="60" > /> > <Resource name="@scc.reports.datasource.name@" > auth="Container" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > type="javax.sql.DataSource" maxActive="100" > minIdle="10" maxIdle="30" > maxWait="10000" > username="@scc.reports.datasource.username@" > password="@scc.reports.datasource.password@" > driverClassName="@scc.reports.datasource.driver@" > url="@scc.reports.datasource.driverurl@" logAbandoned="true" > validationQuery="SELECT 1" > removeAbandoned="true" > testOnBorrow="true" > testWhileIdle="true" > timeBetweenEvictionRunsMillis="10000" > minEvictableIdleTimeMillis="180000" > removeAbandonedTimeout="60" > /> > <Resource name="@scc.tickets.datasource.name@" > auth="Container" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > type="javax.sql.DataSource" maxActive="100" > minIdle="10" maxIdle="30" > maxWait="10000" > username="@scc.tickets.datasource.username@" > password="@scc.tickets.datasource.password@" > driverClassName="@scc.tickets.datasource.driver@" > url="@scc.tickets.datasource.driverurl@" > validationQuery="SELECT 1" > removeAbandoned="true" > testOnBorrow="true" > testWhileIdle="true" > timeBetweenEvictionRunsMillis="10000" > minEvictableIdleTimeMillis="180000" > removeAbandonedTimeout="60" > /> > <Resource name="@monitoring.datasource.name@" > auth="Container" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > type="javax.sql.DataSource" maxActive="100" > minIdle="10" maxIdle="30" > maxWait="10000" > username="@monitoring.datasource.username@" > password="@monitoring.datasource.password@" > driverClassName="@monitoring.datasource.driver@" > url="@monitoring.datasource.driverurl@" > validationQuery="SELECT 1" > removeAbandoned="true" > testOnBorrow="true" > testWhileIdle="true" > timeBetweenEvictionRunsMillis="10000" > minEvictableIdleTimeMillis="180000" > removeAbandonedTimeout="60" > /> > I checked my code,There is no problem with closing connections and all. I was tried with upgrading tomcat from 7.0.52 to minor versions of 7.0.x and Major version 8.0.x too. Please tell me the solution permanent solution for this. -- S Saikumar
