Hi We are using Tomcat 9.0.84 and Tomcat DBCP2 connection pool and the DB is Oracle 19c. We are seeing the closed connections and the standment objects are not cleared even after the connection says closed. Anybody faced similar issue ?
Here is the values in tomcat context.xml maxWaitMillis="60000" maxIdle="10" logAbandoned="true" removeAbandonedOnBorrow="true" removeAbandonedOnMaintenance="true" removeAbandonedTimeout="60" removeAbandoned="true" testonBorrow="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="120000" driverClassName="oracle.jdbc.OracleDriver" accessToUnderlyingConnectionAllowed="true" maxTotal="200" type="javax.sql.DataSource" -- நன்றி, அருள்.