Java agent JDBC Connection Pool not showing

Shubham_Wagdark — Wed, 09 Aug 2023 03:07:07 GMT

Hello,

I am facing issue, in my Java agent application i couldn't find JDBC connection pool details there is only thread details available, anyone have any idea about this and how to resolve this issue?

Re: Java agent JDBC Connection Pool not showing

iamryan — Wed, 09 Aug 2023 22:58:21 GMT

Hello @Shubham.Wagdarkar,

I found this existing info. I'm not sure what Controller version you are on, so you may need to adjust the documentation to fit the right version #.

Please search the MBean Browser and see if you can find the metric:
https://docs.appdynamics.com/21.12/en/application-monitoring/configure-instrumentation/configure-jmx-metrics-from-mbeans#ConfigureJMXMetricsfromMBeans-AccesstheMBeanBrowser

If it is not visible in MBean Browser, then it means that the metric has not been exposed on the Spring Boot side. Can you see the metric in JConsole?
https://docs.oracle.com/javase/7/docs/technotes/guides/management/jconsole.html

If you need another way besides Mbeam to get JDBC Connection pool metrics, you can try this.

For some frameworks, for example if you are using Tomcat, then the connection pools should be found by the default detection rules under DataSource if you are using org.apache.tomcat.jdbc.pool.DataSource and set the flag jmxEnabled=true:
https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html

However, if you are not already seeing the metric then it is not at one of the locations where we would auto-detect it, and it would be necessary to find the metric in MBean Browser.

topic Re: Java agent JDBC Connection Pool not showing in Splunk AppDynamics

Java agent JDBC Connection Pool not showing

Re: Java agent JDBC Connection Pool not showing