MBean (JMX) Monitoring and Management

[arun kumar]

While using MBean (JMX) Monitoring and Management  

I have received this error

java.lang.RuntimeException: javax.management.InstanceNotFoundException: com.zaxxer.hikari:type=Pool 

Hikari version : 3.2.0

Database : oracle

Hikari Config:

 config.setDriverClassName("oracle.jdbc.driver.OracleDriver");

        config.setJdbcUrl( "jdbc:oracle:thin:@xx.xx.xx.xx:xxx:arun" );

        config.setUsername( "xx" );

        config.setPassword( "xxx" );

        config.addDataSourceProperty( "cachePrepStmts" , "true" );

        config.addDataSourceProperty( "prepStmtCacheSize" , "250" );

        config.addDataSourceProperty( "prepStmtCacheSqlLimit" , "2048" );

        config.setPoolName("insurance");

        config.setRegisterMbeans(true);

        config.setAllowPoolSuspension(true);

        

        ds = new HikariDataSource( config );

[Brett Wooldridge]

You'll want to make sure that your pool as an assigned name.  Then you need to use that name as part of the JMX lookup.  For example:

ObjectName poolName = new ObjectName("com.zaxxer.hikari:type=Pool (foo)");

where "foo" is the name you assigned to the pool.

-Brett

[arun kumar]

I have used the sample poolName in ObjectName creation.

-Arun

[arun kumar]

Its working. 

On Friday, 21 December 2018 14:38:32 UTC+5:30, Brett Wooldridge wrote: