Search code examples
javaspring-bootdatasourcespring-jdbcintroscope

get JDBC connection monitoring data in introscope for standalone springboot java application

I have a standalone java springboot application which has JDBC connections setup like below:

Java code:

spring:
  datasource:
    hikari:
      driver-class-name: oracle.jdbc.driver.OracleDriver
      jdbc-url: jdbc:oracle:thin:@dbhost:1521/db01.world
      username: WEB_USER
      password: password

I get all Introscope stats like CPU, Heap, THREADS, JMX etc but could not find the number of JDBC connections that my springboot application makes.

Can you please guide me on how to get JDBC stats for springboot in introscope.

Note: We get JDBC stats in introscope for several weblogic and Websphere java application server but not sure how-to for a standalone springboot java application.

Solution

  • I reinstalled the introscope agent 10.7 for tomcat with defaults and that now gives me all monitoring metrics.

    We saw introscope AutoProbe.log which mentioned errors like pbl / pbd files not found error which once fixed lead us to the second file not found and so on. That's where we took a call to do this afresh.