{"id":589,"date":"2014-06-20T19:11:15","date_gmt":"2014-06-20T17:11:15","guid":{"rendered":"http:\/\/www.epischel.de\/wordpress\/?p=589"},"modified":"2014-06-20T22:32:16","modified_gmt":"2014-06-20T20:32:16","slug":"accessing-jdbc-data-source-metrics-from-an-application-on-a-weblogic","status":"publish","type":"post","link":"https:\/\/www.epischel.de\/wordpress\/2014\/06\/accessing-jdbc-data-source-metrics-from-an-application-on-a-weblogic\/","title":{"rendered":"Accessing JDBC Data Source metrics from an application on a Weblogic Server"},"content":{"rendered":"

I recently felt the need for accessing the metrics \/ statistics of a JDBC Data Source from within an application that is deployed on a Oracle Weblogic Server. I did not succeed right away, so I document it here.<\/p>\n

Basically we just need some calls to JMX. Using the Weblogic RuntimeServiceMBean<\/code> we navigate from ServerRuntime<\/code> and JDBCServiceRuntime<\/code> to JDBCDataSourceRuntimeMBeans<\/code>. From there we get ObjectName<\/code>s for each JDBC Data Source that we can access from our application. Using these object names we can retreive the metrics.<\/p>\n

First we get the MBeanServer via JNDI:<\/p>\n

\n\n\t\t
\n\n\t\t
\n\t\t\t\t\t\t< View plain text<\/span> ><\/a>\n\t\t\t\t\t<\/div>\n\n\t\t
java<\/div>\n\n\t\t\n\t\t
\n\n\t<\/div>\n\t\n\t
\n\t\t
  1. MBeanServer getMBeanServer(<\/span>)<\/span> throws<\/span> NamingException<\/span> {<\/span><\/div><\/li>\n
  2.   InitialContext<\/span> ctx =<\/span> new<\/span> InitialContext<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>\n
  3.   MBeanServer server =<\/span> (<\/span>MBeanServer)<\/span> ctx.lookup<\/span>(<\/span>"java:comp\/env\/jmx\/runtime"<\/span>)<\/span>;<\/span><\/div><\/li>\n
  4.   return<\/span> server;<\/span><\/div><\/li>\n
  5. }<\/span><\/div><\/li>\n<\/ol>\t<\/div>\n\n<\/div>\n\n

    Then we navigate as described before:<\/p>\n

    \n\n\t\t
    \n\n\t\t
    \n\t\t\t\t\t\t< View plain text<\/span> ><\/a>\n\t\t\t\t\t<\/div>\n\n\t\t
    java<\/div>\n\n\t\t\n\t\t
    \n\n\t<\/div>\n\t\n\t
    \n\t\t
    1. ObjectName[<\/span>]<\/span> getJdbcDataSourceRuntimeMBeans(<\/span>MBeanServer server)<\/span> <\/div><\/li>\n
    2.       throws<\/span> MalformedObjectNameException, AttributeNotFoundException, MBeanException,<\/div><\/li>\n
    3.       InstanceNotFoundException, ReflectionException {<\/span><\/div><\/li>\n
    4.     ObjectName service =<\/span> new<\/span> ObjectName(<\/span><\/div><\/li>\n
    5. "com.bea:Name=RuntimeService,Type=weblogic.management.mbeanservers.runtime.RuntimeServiceMBean"<\/span>)<\/span>;<\/span><\/div><\/li>\n
    6.     ObjectName serverRT =<\/span> (<\/span>ObjectName)<\/span> server.getAttribute<\/span>(<\/span>service, "ServerRuntime"<\/span>)<\/span>;<\/span><\/div><\/li>\n
    7.     ObjectName jdbcRT =<\/span> (<\/span>ObjectName)<\/span> server.getAttribute<\/span>(<\/span>serverRT, "JDBCServiceRuntime"<\/span>)<\/span>;<\/span><\/div><\/li>\n
    8.     ObjectName[<\/span>]<\/span> dsRTs =<\/span> (<\/span>ObjectName[<\/span>]<\/span>)<\/span> server.getAttribute<\/span>(<\/span>jdbcRT, "JDBCDataSourceRuntimeMBeans"<\/span>)<\/span>;<\/span><\/div><\/li>\n
    9.     return<\/span> dsRTs;<\/span><\/div><\/li>\n
    10.   }<\/span><\/div><\/li>\n<\/ol>\t<\/div>\n\n<\/div>\n\n

      To get the current number of active connections and the current capacity of the connection pool, we access the attributes ActiveConnectionsCurrentCount<\/code> and CurrCapacity<\/code>:<\/p>\n

      \n\n\t\t
      \n\n\t\t
      \n\t\t\t\t\t\t< View plain text<\/span> ><\/a>\n\t\t\t\t\t<\/div>\n\n\t\t
      java<\/div>\n\n\t\t\n\t\t
      \n\n\t<\/div>\n\t\n\t
      \n\t\t
      1. MBeanServer server =<\/span> getMBeanServer(<\/span>)<\/span>;<\/span><\/div><\/li>\n
      2.       ObjectName[<\/span>]<\/span> dsRTs =<\/span> getJdbcDataSourceRuntimeMBeans(<\/span>server)<\/span>;<\/span><\/div><\/li>\n
      3.       for<\/span> (<\/span>ObjectName dsRT :<\/span> dsRTs)<\/span> {<\/span><\/div><\/li>\n
      4.         String<\/span> name =<\/span> (<\/span>String<\/span>)<\/span> server.getAttribute<\/span>(<\/span>dsRT, "Name"<\/span>)<\/span>;<\/span><\/div><\/li>\n
      5.         Integer<\/span> activeConnectionsCurrentCount =<\/span><\/div><\/li>\n
      6.             (<\/span>Integer<\/span>)<\/span> server.getAttribute<\/span>(<\/span>dsRT, "ActiveConnectionsCurrentCount"<\/span>)<\/span>;<\/span><\/div><\/li>\n
      7.         Integer<\/span> currCapacity =<\/span><\/div><\/li>\n
      8.             (<\/span>Integer<\/span>)<\/span> server.getAttribute<\/span>(<\/span>dsRT, "CurrCapacity"<\/span>)<\/span>;<\/span><\/div><\/li>\n
      9.     \/\/ do something with these metrics<\/span><\/div><\/li>\n
      10.       }<\/span><\/div><\/li>\n<\/ol>\t<\/div>\n\n<\/div>\n\n

        There are a bunch of metrics. Here is a list<\/a>. You can enumerate them using MBeanAttrbuteInfo<\/code>:<\/p>\n

        \n\n\t\t
        \n\n\t\t
        \n\t\t\t\t\t\t< View plain text<\/span> ><\/a>\n\t\t\t\t\t<\/div>\n\n\t\t
        java<\/div>\n\n\t\t\n\t\t
        \n\n\t<\/div>\n\t\n\t
        \n\t\t
        1. \/**<\/span><\/div><\/li>\n
        2.    * Returns MBean-Attribute Infos such as Name, Type and Description<\/span><\/div><\/li>\n
        3.    *\/<\/span><\/div><\/li>\n
        4.   public<\/span> MBeanAttributeInfo[<\/span>]<\/span> getMetricsAttributeInfos(<\/span>)<\/span> {<\/span><\/div><\/li>\n
        5.     try<\/span> {<\/span><\/div><\/li>\n
        6.       MBeanServer server =<\/span> getMBeanServer(<\/span>)<\/span>;<\/span><\/div><\/li>\n
        7.       ObjectName[<\/span>]<\/span> dsRTs =<\/span> getJdbcDataSourceRuntimeMBeans(<\/span>server)<\/span>;<\/span><\/div><\/li>\n
        8.       if<\/span> (<\/span>dsRTs.length<\/span>><\/span>0<\/span>)<\/span> {<\/span><\/div><\/li>\n
        9.         return<\/span> server.getMBeanInfo<\/span>(<\/span>dsRTs[<\/span>0<\/span>]<\/span>)<\/span>.getAttributes<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>\n
        10.       }<\/span><\/div><\/li>\n
        11.     }<\/span> catch<\/span> (<\/span>Exception<\/span> e)<\/span> {<\/span><\/div><\/li>\n
        12.       \/\/ your favourite error logging mechanism here...<\/span><\/div><\/li>\n
        13.     }<\/span><\/div><\/li>\n
        14.     return<\/span> new<\/span> MBeanAttributeInfo[<\/span>]<\/span>{<\/span>}<\/span>;<\/span><\/div><\/li>\n
        15.     <\/div><\/li>\n
        16.   }<\/span><\/div><\/li>\n<\/ol>\t<\/div>\n\n<\/div>\n\n

          every MBeanAttributeInfo<\/code> contains name, type and description of the attribute.<\/p>\n

          Note: I am using Weblogic Server 11g here. I have not tried this on WLS 12c.<\/em><\/p>\n

          <\/div>","protected":false},"excerpt":{"rendered":"

          I recently felt the need for accessing the metrics \/ statistics of a JDBC Data Source from within an application that is deployed on a Oracle Weblogic Server. I did not succeed right away, so I document it here. Basically we just need some calls to JMX. Using the Weblogic RuntimeServiceMBean we navigate from ServerRuntime…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"mf2_syndication":[],"webmentions_disabled_pings":false,"webmentions_disabled":false,"footnotes":""},"categories":[3,2],"tags":[120,75,32],"series":[],"class_list":["post-589","post","type-post","status-publish","format-standard","hentry","category-java","category-entwicklung","tag-java","tag-jmx","tag-weblogic","kind-"],"kind":false,"_links":{"self":[{"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/posts\/589","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/comments?post=589"}],"version-history":[{"count":5,"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/posts\/589\/revisions"}],"predecessor-version":[{"id":595,"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/posts\/589\/revisions\/595"}],"wp:attachment":[{"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/media?parent=589"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/categories?post=589"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/tags?post=589"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/www.epischel.de\/wordpress\/wp-json\/wp\/v2\/series?post=589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}