How to view active database connections in Tomcat

Configure remote JMX Connectivity for Tomcat by adding these JAVA OPTIONS -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=9999 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false 2.  Start jmxconsole and connect to the remote tomcat process. 3. Go to MBeans -> Datasource -> Application Name -> Your Datasource -> numActive

Continue reading »