Hi Mark, Thank you for your reply!!
It seems mentioned parameter is already set in jdbc-pool.html (see below) - could you please let us know which log to check for abandoned connection: <p>And here is an example on how to configure a resource for JNDI lookups</p> <div class="codeBox"><pre><code><Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testWhileIdle="true" testOnBorrow="true" testOnReturn="false" validationQuery="SELECT 1" validationInterval="30000" timeBetweenEvictionRunsMillis="30000" maxActive="100" minIdle="10" maxWait="10000" initialSize="10" removeAbandonedTimeout="60" removeAbandoned="true" logAbandoned="true" minEvictableIdleTimeMillis="30000" jmxEnabled="true" jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState; org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer" username="root" password="password" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/mysql"/></code></pre></div> Thanks and Regards, Arpan Arpan Halder Tata Consultancy Services providing services to: Global Data and Analytics Application Support / ITAS Route 22 West▪NJ 08876 ▪ USA Mobile: +1 (908) 392 2947 -----Original Message----- From: Mark Thomas [mailto:ma...@apache.org] Sent: Thursday, February 15, 2018 6:03 AM To: Tomcat Users List <users@tomcat.apache.org>; Halder, Arpan [ITSUS Non J&J] <ahald...@its.jnj.com> Cc: DL-MD-R&D-SUPPORT <DL-HCSUS-MD-R&d-supp...@its.jnj.com> Subject: [EXTERNAL] Re: Cannot get a connection, pool error Timeout waiting for ideal object On 15/02/18 00:35, Halder, Arpan [ITSUS Non J&J] wrote: > Hi All, > > Need urgent help. We are using apache tomcat version -7.0.67 and > sporadically facing issue that application become unresponsive and below > error message encountered in Catalina.out log: > > ExceptionCannot get a connection, pool error Timeout waiting for idle > object Exception in > detailorg.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a > connection, pool error Timeout waiting for idle object within doFilter > of Session Filter url :::::/SPECTRA/login Chain.doFilter().. > Inside Login Method......... > > We had to restart tomcat service every time and issue gets resolved for the > time being and again reappears sporadically. Could you please advise if we > need to change any tomcat setting to mitigate this issue from happening in > future. > > Please let us know if you need anything else from my side in this regards. > Thank you in advance. It sounds like you have a connection leak in your application. Enable abandoned connection logging to find out where the leaked connections are being created. Mark --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org