JDBC data not populated for tomcat added by Prometheus
To configure JDBC metrics in tomcat exporter
1) Open the below file from tomcat installation directory.

$CATALINA_BASE/conf/server.xml
2) Add the following configuration under <GlobalNamingResources> tag in the server.xml file.

<Resource name="<CUSTOM_RESOURCE_NAME>"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
jdbcInterceptors="nl.nlighten.prometheus.tomcat.TomcatJdbcInterceptor(logFailed=true,logSlow=true,threshold=1000,buckets=.01|.05|.1|1|10,slowQueryBuckets=1|10|30)"
username="<DB_USERNAME>"
password="<DB_PASSWORD>"
driverClassName="<JDBC_DRIVER_NAME>"
url="<JDBC_CONNECTION_URL>"/>
3) Restart tomcat server/pod and access the metrics URL:
http://host:port/metrics. Check if JDBC metrics are generated or not.
Eg.
4) Check if the metrics are scraped by Prometheus using PromQL query tool. A query execution example is shown below.
Prometheus query execution5) Now poll the monitor from Applications Manager and verify if JDBC data is populated in the UI.
New to ADSelfService Plus?