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