Get State of Connection Pool Weblogic

[Angelo_Ferecini]

Hi folks, 

I'm trying to capture the State field of the JDBCConnectionPoolRuntime mbean, but I haven't been successful so far. Has anyone tried this? Is it possible to capture strings fields contained in mbeans?

Thank you so much

Carlos Coqueiro

[Morelz · Accepted solution]

Hi Angelo

Seeing as you need to collect metrics, you can't graph strings:)

I would suggest you use a getter chain in JMX like below for the state value you require

Metric Getter Chain: replaceAll(Running,1)

This way you can graph the different states with different integer values as well as create health rule on the values

Ciao

[Angelo_Ferecini]

Hello Mario,

Thank you so much for your suggestion, worked! Another question, for each state I will have a different metric chain, correct?

Thank you so much again.

Ciao

[Morelz]

Anytime:)

If I understand your request correctly, I believe you could use one getter chain.

Can concatenate it together, I haven't tested it but should work as below.

replaceAll(Running,1). replaceAll(Stopped,2). replaceAll(Suspended,3)

That way it stays one metric and the value will change as the state changes.

Otherwise you a create seperate metric chains per status.

Ciao