Example usage for org.apache.commons.dbcp PoolableConnectionFactory validateConnection

Introduction

In this page you can find the example usage for org.apache.commons.dbcp PoolableConnectionFactory validateConnection.

Prototype

public void validateConnection(Connection conn) throws SQLException 

Source Link

Document

根�查询语� #_validationQuery �查询超时 #_validationQueryTimeout 测试 Connection conn 是�正常

Usage

From source file:org.agnitas.dao.LoggingEnhBasicDataSource.java

private static void validateConnectionFactory(PoolableConnectionFactory connectionFactory) throws Exception {
    Connection conn = null;/* w w w.j av a2  s .  c o  m*/
    try {
        conn = (Connection) connectionFactory.makeObject();
        connectionFactory.activateObject(conn);
        connectionFactory.validateConnection(conn);
        connectionFactory.passivateObject(conn);
    } finally {
        connectionFactory.destroyObject(conn);
    }
}

---