This discussion is archived
0 Replies Latest reply: Oct 23, 2012 2:53 PM by 970278 RSS

Issue with dynamic Oracle UCP UniversalConnectionPoolManager name in JMX

970278 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points