-----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
