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:org.openkoala.koala.monitor.support.DbcpDataSourceCollector.java

public synchronized JdbcPoolStatusVo currentPoolStatus() {
    JdbcPoolStatusVo poolStatus = new JdbcPoolStatusVo();
    try {/*from ww  w  .  j  a v  a  2 s.c  o  m*/
        BasicDataSource realDS = (BasicDataSource) dataSoure;

        poolStatus.setDriverName(realDS.getDriverClassName());
        //         poolStatus.setStartTime();
        poolStatus.setProvider(dataSoure.getClass().getName());
        poolStatus.setInitConnectionCount(realDS.getInitialSize());
        poolStatus.setMaxConnectionCount(realDS.getMaxActive());
        poolStatus.setMaxActiveTime(realDS.getMaxWait());

        poolStatus.setMaxOpenStatements(realDS.getMaxOpenPreparedStatements());
        poolStatus.setSnapshotTime(new Date());
        poolStatus.setIdleConnectionCount(realDS.getNumIdle());
        poolStatus.setActiveConnectionCount(realDS.getNumActive());
    } catch (Exception e) {
        poolStatus.setErrorTip("??");
    }

    return poolStatus;
}

From source file:org.sakaiproject.status.StatusServlet.java

protected void reportSakaiDatabaseStatus(HttpServletResponse response) throws Exception {
    PrintWriter pw = response.getWriter();

    BasicDataSource db = (BasicDataSource) ComponentManager.get("javax.sql.DataSource");
    if (db == null) {
        throw new Exception("No data source found.");
    }/*from www .  j  a v  a  2  s  .c  o  m*/

    pw.print(db.getNumActive() + "," + db.getNumIdle() + "\n");
}

From source file:psiprobe.beans.DbcpDatasourceAccessor.java

@Override
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  . j  a v  a 2  s  .c  o m
    return dataSourceInfo;
}

From source file:samples.BasicDataSourceExample.java

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