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.
Eg.
4) Check if the metrics are scraped by Prometheus using PromQL query tool. A query execution example is shown below.
5) Now poll the monitor from Applications Manager and verify if JDBC data is populated in the UI.
New to ADSelfService Plus?
Related Articles
Data is not being properly populated for Tomcat 5 and above versions in APM. How can I check for correct data?
To check whether data collected properly or not, access the below URLs : For versions below 5.x: http://<Tomcat Host>:<Port>/adventnet/DataServlet For Versions 5.x and above: Server Info: http://<Tomcat ...How to configure Tomcat Exporter to scrape metrics from Prometheus?
To setup exporter, follow the steps given below: Install a standalone Tomcat-sever or as a container as kubernetes cluster. Download the Tomcat exporter servlet file in .war format from here. Rename the file as metrics.war and deploy it in the ...Applications Manager is not collecting data from Tomcat Server.
If the proxy settings are configured wrong, then Tomcat Data collection will not happen correctly as Applications Manager uses HTTP requests for data collection from Tomcat Server. Check if you are able to access the Tomcat Server from browser in ...No data available (or) error in Biztalk Server monitor added in WMI mode
If data is not available or if you encounter any error during data collection for Biztalk Server monitor added in WMI mode, follow the steps below: If you are using AppManager version 15470 and above, you can navigate to Admin > Self Help Tools and ...Applications Manager default tomcat is down
If your Tomcat Monitor is down, it could probably be due to changes in Hostname/IP address of the machine in which Applications Manager is installed. You can verify the same using the steps given below: Navigate to ...