ср, 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&characterEncoding=UTF-8&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