Unable to reset Reconnect Count in JDBCConnection PoolRuntime MBean

[Biswajit Paria]

Hi All,
I am using weblogic JDBCConnectionPoolRuntimeMBean (weblogic.management.runtime.JDBCConnectionPoolRuntimeMBean) to get detail status regarding JDBC connection while running an application on Weblogic.

Using:

[B]weblogic.management.runtime.JDBCConnectionPoolRuntimeMBean connBean = getJDBCConnectionBean(pool[i]);[/B]
 
 private weblogic.management.runtime.JDBCConnectionPoolRuntimeMBean getJDBCConnectionBean(String poolName) throws Exception
    {
      javax.naming.InitialContext ctx = new javax.naming.InitialContext();
      String name = Globals.DEVELOPMENT.equals(Globals.MODE)?"admin":"webtest";
 
      weblogic.management.MBeanHome mbeanHome = (weblogic.management.MBeanHome)ctx.lookup(weblogic.management.MBeanHome.ADMIN_JNDI_NAME);
     
      //Create a WebLogic object name for the Server MBean
      //to use to create a name for the JDBCConnectionPoolRuntime MBean.
      weblogic.management.WebLogicObjectName pname = new weblogic.management.WebLogicObjectName(name, "ServerRuntime", mbeanHome.getDomainName(),name);
      
      //Create a WebLogic object name for the JDBCConnectionPoolRuntime MBean
      //to use to create or get the JDBCConnectionPoolRuntime MBean.
      weblogic.management.WebLogicObjectName oname = new weblogic.management.WebLogicObjectName(poolName, "JDBCConnectionPoolRuntime", mbeanHome.getDomainName(),name, pname);
     
         
      return (weblogic.management.runtime.JDBCConnectionPoolRuntimeMBean)mbeanHome.getMBean(oname);
    
    }
    

Then I used

  if( connBean.getFailuresToReconnectCount() > 0 )
              {
                printWarning(out, connBean.getFailuresToReconnectCount() + " times Jdbc connections have failed to re-connect to database " + pool[i] + "("+ pool[i+1] + ").\n<br>");
                              }   

Using that above code, I get total number of try that connection pool tries to reconenct database but failed(at the time while database was not available or there is any network problem between application and database.)

Problem, I am facing:
Though the above code works fine, but after database is up and Network problem resolved, I still find the same count for connBean.getFailuresToReconnectCount(), it is not reset

I want, after database and network issues resolved, this count should be reset to Zero.

I tried to use reset() method, but it does not work.

  weblogic.management.runtime.JDBCConnectionPoolRuntimeMBean connBean = getJDBCConnectionBean(pool[i]);
              [B]connBean.reset(); [/B]  

Please advice.

Thanks in advance.

-Biswajit.

[Biswajit Paria]

More information:
I am using weblogic v7.0 and applications are deployed in admin server only.