Hi Chris, Thank you for your reply!!
We could locate the parameters in "jdbc-pool.html" file located under apache-tomcat-7.0.67/webapps/docs" path. Is there somewhere else we need to look into for this file? Could you please advise on where we could find the file. Also in case the mentioned file is correct file but it is not configured for our database - could you please let me know what is the process of modification/setting up parameters and what are the parameters we need to set in case it is not done for our case. Thank you in advance and appreciate your help!! 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: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: Friday, February 16, 2018 2:24 PM To: users@tomcat.apache.org Subject: [EXTERNAL] Re: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Arpan, On 2/15/18 8:54 AM, Halder, Arpan [ITSUS Non J&J] wrote: > We have already setup below parameters in jdbc-pool.html (see > below) – could you please advise if we need to modify/add anything > else here: > > <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.ConnectionSt ate; > > 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> Looks like you copy/pasted that from the Tomcat documentation. How about copy/pasting your actual configuration (without any secrets, of course) just in case there are any errors in your interpretation. Are you sure you don't have capacity problems? If you have only e.g. 10 connections available but hundreds of users, perhaps you simply need more connections. Are you sure the database is available and reachable via the network? Sometimes timeouts are simply a reality. But if you start to see "timeout" errors and the database is NOT DOWN and still reachable, but everything grinds to a halt, then you certainly have a resource problem. I disagree with another poster about abandoned connections: do not remove them. Log them and allow the pool to become exhausted. That way, you'll end up finding and fixing the problems instead of just continuing to bleed. - -chris -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlqHL+YACgkQHPApP6U8 pFgbDxAAhmn6nD0edc0F/3eh3izdZ9KnV5sUAC/E5ubv/1tc+KiE/GPZUhiy/qSa n4Am3KEhXmyee+ZcQFUg1PNqeZGgq/uLdppeZHG0Vsv0lYH/I1xBJMoluEpDzzQN nnRFQEHCqlB+ujBP5G4bQGLRuh5fhwVRz9lktoQnwDybG/KjzTh56+SZmYXABSEn JMFEbr6+ADafPVUiSmu8uMklenH5YXYMXiiB6dAXdtpP/SHAGxko05c0j1g+Snq1 WrM17qKpGI2qdQaXlfr8NChBuXrNQz8zj+2HJrNxzRLDa56GmVBq7tbvgwQwmdTb r1vqW1sEl4l3y8fnUxFJlyoQixQ8wPKDQH7H8NPpMkts4SyRULqRwpJvp6/L+TYy D8Ge2j+9uZCxUcccA0ds3E8j1r+FjtpU6w8Ut1ZJIb071JmtEDlvRTYyAEt0Q69w 3MJa0dA59DJ8l4/A2KzNuDhFYtkmuf1UmBHxw6qsfqsseqFD3AzDVcbirpxwNdIj 1mtbH91Fl+hSN4Ww4gGQLXjUfLf1o8MR0bkeLy5236k2UajuH1Jbvf8xCh6GlQoc yp7PH61Kw5vb2M5Yjqg0C0OSgXspagYYATCM4Y2QTBATUrpLHTLYv679yKXCMPgq wQlvIn4+jpxnFpB2fhY5ZWH0VdilWhXG8uhGz2FJCI9XhWUaAws= =vd5m -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org