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 ...APM Insight monitor is UP, but monitor page doesn't show any data
Possible Causes The APM Insight monitor status corresponds to the respective agent folder pointed Java Application status i.e., as long as the Application server is running, the monitor status will be UP. 1. No Transactions Recorded: It is possible ...Discovering Tomcat server fails and it displays "Manageengine Agent has to be deployed for collecting the data from Tomcat Server".
Reason: Tomcat 3.x and 4.x cannot be discovered if Manageengine Agents are not deployed in it. Solution: To discover Tomcat 3.x and 4.x, download Manageengine agents, Tomcat3Agent.zip and Tomcat4Agent.zip respectively, that are bundled with ...