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

Introduction

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

Prototype

public PoolableConnectionFactory(ConnectionFactory connFactory, ObjectPool pool,
        KeyedObjectPoolFactory stmtPoolFactory, String validationQuery, int validationQueryTimeout,
        Collection connectionInitSqls, Boolean defaultReadOnly, boolean defaultAutoCommit,
        int defaultTransactionIsolation, String defaultCatalog, AbandonedConfig config) 

Source Link

Document

Create a new PoolableConnectionFactory.

Usage

From source file:org.jumpmind.db.util.ResettableBasicDataSource.java

@Override
protected void createPoolableConnectionFactory(ConnectionFactory driverConnectionFactory,
        KeyedObjectPoolFactory statementPoolFactory, AbandonedConfig configuration) throws SQLException {
    PoolableConnectionFactory connectionFactory = null;
    try {/*  ww w .ja  v a2s . co  m*/
        connectionFactory = new PoolableConnectionFactory(driverConnectionFactory, connectionPool,
                statementPoolFactory, validationQuery, validationQueryTimeout, connectionInitSqls,
                defaultReadOnly, defaultAutoCommit, defaultTransactionIsolation, defaultCatalog, configuration);
        validateConnectionFactory(connectionFactory);
    } catch (Exception e) {
        try {
            connectionPool.close();
        } catch (Exception e1) {
        }
        throw new SQLNestedException("Cannot create PoolableConnectionFactory (" + e.getMessage() + ")", e);
    }
}

---

From source file:org.openconcerto.sql.model.SQLDataSource.java

@Override
protected void createPoolableConnectionFactory(ConnectionFactory driverConnectionFactory,
        @SuppressWarnings("rawtypes") KeyedObjectPoolFactory statementPoolFactory,
        AbandonedConfig configuration) throws SQLException {
    PoolableConnectionFactory connectionFactory = null;
    try {//  w  w w  .ja va 2  s .  c  o  m
        connectionFactory = new PoolableConnectionFactory(driverConnectionFactory, this.connectionPool,
                statementPoolFactory, this.validationQuery, this.validationQueryTimeout,
                this.connectionInitSqls, this.defaultReadOnly, this.defaultAutoCommit,
                this.defaultTransactionIsolation, this.defaultCatalog, configuration) {
            @Override
            public Object makeObject() throws Exception {
                Connection conn = this._connFactory.createConnection();
                if (conn == null) {
                    throw new IllegalStateException("Connection factory returned null from createConnection");
                }
                initializeConnection(conn);
                setTransactionIsolation(conn);
                if (null != this._stmtPoolFactory) {
                    @SuppressWarnings("rawtypes")
                    KeyedObjectPool stmtpool = this._stmtPoolFactory.createPool();
                    conn = new PoolingConnection(conn, stmtpool);
                    stmtpool.setFactory((PoolingConnection) conn);
                }
                return new TransactionPoolableConnection(conn, this._pool, this._config);
            }
        };
        validateConnectionFactory(connectionFactory);
    } catch (RuntimeException e) {
        throw e;
    } catch (SQLException e) {
        // only wrap if necessary (calling code can use SQLState)
        throw e;
    } catch (Exception e) {
        throw new SQLException("Cannot create PoolableConnectionFactory", e);
    }
}

---