0 Replies Latest reply: Jan 8, 2015 1:56 PM by 970278 RSS

    Issue with dynamic Oracle UCP UniversalConnectionPoolManager name in JMX

    970278

      Hi,

      We are using UCP 11g R3 with Tomact 6. We have configured SiteScope to monitor UCP's borrowedConnectionCount through JMX.
      One problem that we are facing is that the MBean object name is dynamically changing on every JVM recycle.

      The MBean name listed under oracle.ucp.admin.UniversalConnectionPoolMBean is in this format,

      UniversalConnectionPoolManager-7745766443905610782-2-<hostname>

      The number 7745766443905610782 is dynamic on every JVM recycle. So we have to change MBean name every time in SiteScope.

      Here is the datasource configuration,

      <Resource name="jdbc/myDSN"
      auth="Container"
      type="oracle.ucp.jdbc.PoolDataSource"
      factory="oracle.ucp.jdbc.PoolDataSourceImpl"
      connectionFactoryClassName="oracle.jdbc.pool.OracleDataSource"
      url="...."
      . . .
      connectionPoolName="MyDBPool"
      validateConnectionOnBorrow="true"
      sqlForValidateConnection="select 1 from DUAL"
      />

      Is there any configuration to set this MBean name?

      Thanks.