Example usage for org.apache.commons.dbcp BasicDataSource getNumIdle

Introduction

In this page you can find the example usage for org.apache.commons.dbcp BasicDataSource getNumIdle.

Prototype

public synchronized int getNumIdle() 

Source Link

Document

[Read Only] The current number of idle connections that are waiting to be allocated from this data source.

Usage

From source file:br.com.linuxgames.model.dao.core.LinuxGamesDataSource.java

private static void printDataSourceStats() {
    BasicDataSource bds = (BasicDataSource) dataSource;
    logger.info("NumActive: " + bds.getNumActive() + " NumIdle: " + bds.getNumIdle());
}

---

From source file:BasicDataSourceExample.java

public static void printDataSourceStats(DataSource ds) {
    BasicDataSource bds = (BasicDataSource) ds;
    System.out.println("NumActive: " + bds.getNumActive());
    System.out.println("NumIdle: " + bds.getNumIdle());
}

---

From source file:com.hangum.tadpole.engine.manager.TadpoleSQLManager.java

/**
 * dbcp pool info//  w  w w. java 2s . co m
 * 
 * @return
 */
public static List<DBCPInfoDAO> getDBCPInfo() {
    List<DBCPInfoDAO> listDbcpInfo = new ArrayList<DBCPInfoDAO>();

    Set<String> setKeys = getDbManager().keySet();
    for (String stKey : setKeys) {

        SqlMapClient sqlMap = dbManager.get(stKey);
        DataSource ds = sqlMap.getDataSource();
        BasicDataSource bds = (BasicDataSource) ds;

        String[] strArryKey = StringUtils.splitByWholeSeparator(stKey, PublicTadpoleDefine.DELIMITER);
        if (!DBDefine.TADPOLE_SYSTEM_DEFAULT.getDBToString().equals(strArryKey[1])) {

            DBCPInfoDAO dao = new DBCPInfoDAO();
            dao.setDbSeq(Integer.parseInt(strArryKey[0]));
            dao.setDbType(strArryKey[1]);
            dao.setDisplayName(strArryKey[2]);

            dao.setNumberActive(bds.getNumActive());
            dao.setMaxActive(bds.getMaxActive());
            dao.setNumberIdle(bds.getNumIdle());
            dao.setMaxWait(bds.getMaxWait());

            listDbcpInfo.add(dao);
        }
    }

    return listDbcpInfo;
}

---

From source file:jeeves.server.resources.Stats.java

public Stats(final ServiceContext context) {
    DataSource source = context.getBean(DataSource.class);
    if (source instanceof BasicDataSource) {
        BasicDataSource basicDataSource = (BasicDataSource) source;
        numActive = basicDataSource.getNumActive();
        numIdle = basicDataSource.getNumIdle();
        maxActive = basicDataSource.getMaxActive();
    } else {/* w w  w  .  j av  a  2  s  .  c  o  m*/
        maxActive = numActive = numIdle = -1;
    }
    resourceSpecificStats = new HashMap<String, String>();
}

---

From source file:com.spankr.tutorial.TestConnectionDAO.java

/**
 * Print out how many active and idle connections currently exist in the datasource
 *///from w ww . j av a  2s. c  om
private void printActiveConnections() {
    BasicDataSource bds = (BasicDataSource) ds;
    log.debug(String.format("Number of active/idle connections: %s/%s", bds.getNumActive(), bds.getNumIdle()));
}

---

From source file:com.googlecode.psiprobe.beans.DbcpDatasourceAccessor.java

public DataSourceInfo getInfo(Object resource) throws Exception {
    DataSourceInfo dataSourceInfo = null;
    if (canMap(resource)) {
        BasicDataSource source = (BasicDataSource) resource;
        dataSourceInfo = new DataSourceInfo();
        dataSourceInfo.setBusyConnections(source.getNumActive());
        dataSourceInfo.setEstablishedConnections(source.getNumIdle() + source.getNumActive());
        dataSourceInfo.setMaxConnections(source.getMaxActive());
        dataSourceInfo.setJdbcURL(source.getUrl());
        dataSourceInfo.setUsername(source.getUsername());
        dataSourceInfo.setResettable(false);
        dataSourceInfo.setType("commons-dbcp");
    }/*from   w  w  w  .ja  va  2s.  co m*/
    return dataSourceInfo;
}

---

From source file:database.DataSourceBase.java

public void printDataSourceStats() {
    BasicDataSource bds = (BasicDataSource) datasource;
    System.out.println("NumActive: " + bds.getNumActive());
    System.out.println("NumIdle: " + bds.getNumIdle());
}

---

From source file:net.certifi.audittablegen.PostgresqlDMR.java

public void printDataSourceStats() {
    try {//from  w  w w  . j  a v  a  2 s.  c o  m
        if (dataSource.isWrapperFor(BasicDataSource.class)) {
            BasicDataSource bds = dataSource.unwrap(BasicDataSource.class);
            System.out.println("NumActive: " + bds.getNumActive());
            System.out.println("NumIdle: " + bds.getNumIdle());

        } else {
            System.out.println("DataSource Stats not available");
        }
    } catch (SQLException ex) {
        logger.error("Error getting DataSource stats:" + ex.getMessage());
    }

}

---

From source file:net.certifi.audittablegen.HsqldbDMR.java

public void printDataSourceStats() {
    try {//from w ww  .j a v  a  2 s. co  m
        if (dataSource.isWrapperFor(BasicDataSource.class)) {
            BasicDataSource bds = dataSource.unwrap(BasicDataSource.class);
            logger.debug("NumActive: {}", bds.getNumActive());
            logger.debug("NumIdle: {}", bds.getNumIdle());

        } else {
            logger.warn("DataSource Stats not available");
        }
    } catch (SQLException ex) {
        logger.error("Error getting stats", ex);
    }

}

---

From source file:de.iteratec.iteraplan.persistence.RoutingDataSource.java

/**
 * Write current utilization values for the passed data source source to the log (on DEBUG level). Log entries are written in intervals of at least
 * five seconds. This is intended so that the log is not flooded.
 * /*ww w .j a va  2 s .c  om*/
 * @param ds
 *          The DataSource to inspect. Right now, only {@link BasicDataSource} is supported, other implementations will be silently skipped.
 * @param dbname
 *          The name of the DataSource, as it is registered in the RoutingDataSource.
 */
@SuppressWarnings("boxing")
protected void logPoolUtilization(DataSource ds, String dbname) {
    if (!(ds instanceof BasicDataSource)) {
        // cannot retrieve values from other types, so skip
        return;
    }

    long currentTime = System.currentTimeMillis();
    // log at most every five seconds
    if (currentTime - previousLoggingTimestamp < 5000) {
        return;
    }

    previousLoggingTimestamp = currentTime;
    BasicDataSource bds = (BasicDataSource) ds;
    int bdsNumActive = bds.getNumActive();
    int bdsMaxActive = bds.getMaxActive();
    int bdsNumIdle = bds.getNumIdle();

    LOGGER.debug("DS {0}, {1} active, {2} idle, {3} max total", dbname, bdsNumActive, bdsNumIdle, bdsMaxActive);
}

---

• «
• 1
• 2
• 3
• »