On Mon, Jul 10, 2017 at 3:20 PM, Sai Kumar <saikumarsapar...@gmail.com> wrote:
> 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. > > Can you share your code that looks up for connection? > > 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 > -- Guang <http://javadevnotes.com/java-double-to-int/>
