Using JMX to query DbAdapter ConnectionPool and JCA Connection states/statistics - And output statistics only if Reserved Connections are less than a threshold and/or only when number of Reserved Connections change.

(Doc ID 2354587.1)

Last updated on JANUARY 30, 2018

Applies to:

Oracle SOA Suite - Version 12.2.1.0.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Goal

The following document outlines how to setup the BPEL -> DB Adapter testcase that was used to test this program and load the Db Adapter connection pool:

How to set up a BPEL Composite that executes a PL/SQL Stored Procedure through JCA DB Adapter and simulate timeouts. (Doc ID 2352593.1)

The following doc outlines the setup and running of a JMX program:

Using JMX to query and execute SOA/Weblogic MBeans to diagnose and monitor SOA problems or automate SOA solutions (Doc ID 2275890.1)

Then the following document shows how to query DB Adapter connection pool values:

Document : 2354398.1 - Using JMX to query DbAdapter ConnectionPool values

Then the following document added logic to print out only under certain conditions to more finely target collection.

Document : 2354466.1 - Using JMX to query DbAdapter ConnectionPool values - Then output statistics only if Reserved Connections are less than a threshold and/or only when Reserved Connections changes.

Here in this document a list of JCA Connections are printed along with their associated attributes:

The MBean used here is:

This class is used for monitoring a WebLogic Connector Connection Pool:

MBean Name com.bea:Name=eis/DB/scottconnection,ServerRuntime=soa_server1,Location=soa_server1,Type=ConnectorConnectionPoolRuntime,ApplicationRuntime=DbAdapter,ConnectorComponentRuntime=DbAdapter
Description

This bean contains the info for Each Connection:

com.bea:Type=ConnectorConnectionRuntime,Location=soa_server1,ConnectorConnectionPoolRuntime=eis/DB/scottconnection,ApplicationRuntime=DbAdapter,Name=*,ServerRuntime=soa_server1,ConnectorComponentRuntime=DbAdapter

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms