ср, 22 февр. 2023 г. в 01:31, Artur Tomusiak - Hannon Hill
<artur.tomus...@hannonhill.com>:
>
> After upgrading from Tomcat 9.0.33 to Tomcat 9.0.69,

Note that using a binary search (bisection) one could limit the version range.

Alternatively, it is possible to reconfigure the pool to use Apache
Commons DBCP 2 and Apache Commons Pool 2 directly (instead of
package-renamed version used by Tomcat), and bisect their version
ranges.

> [...]
>
> Here is our database connection configuration in context.xml file:
>
>   <Resource
>     name="jdbc/CascadeDS"
>     auth="Container"
>     type="javax.sql.DataSource"
>     username="@{dbusername}"
>     password="@{dbpassword}"
>     driverClassName="com.mysql.jdbc.Driver"
>
> url="jdbc:mysql://@{dbhostport}/@{dbname}?useUnicode=true&amp;characterEncoding=UTF-8&amp;useSSL=false"
>     maxTotal="250"
>     maxIdle="10"

Only 10 idle connections are allowed?

So if you have 250 active connections, only 10 of them can be returned
to the pool, and the other 240 of them have to be closed and reopened.

How many active connections do you usually have? Are those numbers adequate?

>     maxWaitMillis="3000"
>     removeAbandonedOnBorrow="true"
>     removeAbandonedOnMaintenance="true"
>     removeAbandonedTimeout="300"
>     logAbandoned="true"
>     testOnBorrow="true"
>     testOnCreate="true"

I do not see a "validationQuery", so you are relying on
connection.isValid() for those tests...

Why do you need a "testOnCreate" ?

>   />

Best regards,
Konstantin Kolinko

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to