Alan,

> -----Original Message-----
> From: Alan F <shiva...@hotmail.com>
> Sent: Friday, January 21, 2022 6:53 AM
> To: Tomcat Users List <users@tomcat.apache.org>
> Subject: RE: Tomcat jdbc connections
> 
> Hi Christopher
> 
> Thanks for your time here.
> 
> You mean like, a connection is made, no queries are executed, and then the
> connection is terminated?
> - ANSWER -  DBAs are saying connections last a minute or so and are replaced
> by a new set of connections 1 session each pool.
> 
> 
> Presumably, you have an application running on Tomcat with a JDBC
> connection configured. Are you using Tomcat's built-in pooling, or is your
> application managing its own pooling/connections?
> - ANSWER we are using dbcp2
> 
> 
> Do you have any background tasks (in the JVM) that will run even when
> there is no user activity? Cache-management? Lazy-writes?
> - ANSWER I don't think so.
> 
> 
> Are you using Tomcat's clustering? Are you using a database-backed session
> management or any kind? -
> - ANSWER YES clustered B node down, A node up this Tomcat node is not live
> or receiving any traffic currently in test.
> 
> 
> Are the connections definitely being made from the application itself and/or
> Tomcat? Or do you just see those connections coming from the IP where the
> application is running? - ANSWER im assuming according to server.xml they
> are utlising these declared connections via Tomcat.
> 
> 
> Do you have any background tasks (outside the JVM) that will run even when
> there are no user actions? For example, some monitoring system that pings
> the server to say "can you reach the database?" - ANSWER NO
> 
> 
> O
> 

Could your pool be closing the connections after a set time?  Look at 
timeBetweenEvictionRunsMillis and maxConnLifetimeMillis here:

https://commons.apache.org/proper/commons-dbcp/configuration.html

Reply via email to