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

Introduction

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

Prototype

public PoolingDataSource(ObjectPool pool) 

Source Link

Usage

From source file:com.adviser.osgi.db.datasource.base.IPojoPoolingDataSource.java

@Validate
public void start() {
    poolingDataSource = new PoolingDataSource(dataSourceParams.poolableConnectionFactory.getPool());
}

---

From source file:com.ewcms.plugin.externalds.generate.service.dbcp.DbcpDataSource.java

public DbcpDataSource(ObjectPoolFactory objectPoolFactory, String url, String username, String password) {
    connectionPool = createPool(objectPoolFactory);
    createPoolableConnectionFactory(url, username, password);

    dataSource = new PoolingDataSource(connectionPool);
}

---

From source file:com.tethrnet.manage.util.DSPool.java

/**
 * register the data source for H2 DB/*from  w w w  .ja  va  2 s  . c o  m*/
 *
 * @return pooling database object
 */

private static PoolingDataSource registerDataSource() {

    // create a database connection
    String user = "tethrnetbox";
    String password = "filepwd 45WJLnwhpA47EepT162hrVnDn3vYRvJhpZi0sVdvN9Sdsf";
    String connectionURI = "jdbc:h2:" + DB_PATH + "/tethrnetbox;CIPHER=AES";

    String validationQuery = "select 1";

    try {
        Class.forName("org.h2.Driver");
    } catch (ClassNotFoundException ex) {
        log.error(ex.toString(), ex);
    }

    GenericObjectPool connectionPool = new GenericObjectPool(null);

    connectionPool.setMaxActive(25);
    connectionPool.setTestOnBorrow(true);
    connectionPool.setMinIdle(2);
    connectionPool.setMaxWait(15000);
    connectionPool.setWhenExhaustedAction(GenericObjectPool.WHEN_EXHAUSTED_BLOCK);

    ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(connectionURI, user, password);

    new PoolableConnectionFactory(connectionFactory, connectionPool, null, validationQuery, false, true);

    return new PoolingDataSource(connectionPool);

}

---

From source file:com.hangum.tadpole.tajo.core.connections.manager.ConnectionPoolManager.java

private static DataSource makePool(UserDBDAO userDB) {
    GenericObjectPool connectionPool = new GenericObjectPool();
    connectionPool.setMaxActive(5);// w  w  w . j ava  2s  . c  om
    //      connectionPool.setWhenExhaustedAction((byte)1);
    //      connectionPool.setMaxWait(1000 * 60);                // 1.
    //      connectionPool.setTimeBetweenEvictionRunsMillis(3 * 1000);
    connectionPool.setTestWhileIdle(true);

    String passwdDecrypt = "";
    try {
        passwdDecrypt = CipherManager.getInstance().decryption(userDB.getPasswd());
    } catch (Exception e) {
        passwdDecrypt = userDB.getPasswd();
    }
    ConnectionFactory cf = new DriverManagerConnectionFactory(userDB.getUrl(), userDB.getUsers(),
            passwdDecrypt);

    PoolableConnectionFactory pcf = new PoolableConnectionFactory(cf, connectionPool, null, null, false, true);
    DataSource ds = new PoolingDataSource(connectionPool);
    mapDataSource.put(getKey(userDB), ds);

    return ds;
}

---

From source file:com.keybox.manage.util.DSPool.java

/**
 * register the data source for H2 DB//from  w w  w.j ava2 s .c o  m
 *
 * @return pooling database object
 */

private static PoolingDataSource registerDataSource() {

    // create a database connection
    String user = "keybox";
    String password = "filepwd 45WJLnwhpA47EepT162hrVnDn3vYRvJhpZi0sVdvN9Sdsf";
    String connectionURI = "jdbc:h2:" + getDBPath() + "/keybox;CIPHER=AES";

    String validationQuery = "select 1";

    try {
        Class.forName("org.h2.Driver");
    } catch (ClassNotFoundException ex) {
        log.error(ex.toString(), ex);
    }

    GenericObjectPool connectionPool = new GenericObjectPool(null);

    connectionPool.setMaxActive(MAX_ACTIVE);
    connectionPool.setTestOnBorrow(TEST_ON_BORROW);
    connectionPool.setMinIdle(MIN_IDLE);
    connectionPool.setMaxWait(MAX_WAIT);
    connectionPool.setWhenExhaustedAction(GenericObjectPool.WHEN_EXHAUSTED_BLOCK);

    ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(connectionURI, user, password);

    new PoolableConnectionFactory(connectionFactory, connectionPool, null, validationQuery, false, true);

    return new PoolingDataSource(connectionPool);

}

---

From source file:com.markhwood.jndi.EphemeralContext.objectProviders.CommonsDBCPDataSource.java

public Object interpret(String uri, String localName, String qName, Attributes attributes) {
    // FIXME where does wrapped datasource come in?
    GenericObjectPool connectionPool = new GenericObjectPool(null);
    ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(attributes.getValue("url"),
            attributes.getValue("user"), attributes.getValue("password"));
    PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory,
            connectionPool, null, null, false, true);
    PoolingDataSource dataSource = new PoolingDataSource(connectionPool);
    return dataSource;
}

---

From source file:de.fct.companian.analyze.helper.DbHelper.java

public static DataSource createDataSource(Properties properties) {
    String dbDriver;/*w w w . j  a  v a  2 s. c  o m*/
    String dbUrl;
    String dbUser;
    String dbPass;
    String dbDriverDefault = "com.mysql.jdbc.Driver";
    String dbUrlDefault = "jdbc:mysql://localhost:3306/cpanalyze";
    String dbUserDefault = "cpanalyze";
    String dbPassDefault = "ezylanapc";

    if (properties != null) {
        dbDriver = properties.getProperty("database.driver");
        if (dbDriver == null) {
            dbDriver = dbDriverDefault;
        }

        dbUrl = properties.getProperty("database.url");
        if (dbUrl == null) {
            dbUrl = dbUrlDefault;
        }

        dbUser = properties.getProperty("database.username");
        if (dbUser == null) {
            dbUser = dbUserDefault;
        }

        dbPass = properties.getProperty("database.password");
        if (dbPass == null && dbUser.equals("cpanalyze")) {
            dbPass = dbPassDefault;
        }
    } else {
        dbDriver = dbDriverDefault;
        dbUrl = dbUrlDefault;
        dbUser = dbUserDefault;
        dbPass = dbPassDefault;
    }

    logger.debug("createDataSource() loading underlying JDBC driver.");
    try {
        Class.forName(dbDriver);
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }

    ObjectPool connectionPool = new GenericObjectPool(null);
    ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(dbUrl, dbUser, dbPass);
    PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory,
            connectionPool, null, null, false, true);
    PoolingDataSource ds = new PoolingDataSource(connectionPool);

    if (ds == null) {
        logger.error("createDataSource() could not create data source");
    }

    return ds;
}

---

From source file:com.aaasec.sigserv.cscommon.SqLiteConnectionPool.java

private static DataSource setupDataSource(String connectURI, String userName, String password) {
    ObjectPool connectionPool = new GenericObjectPool(null);
    ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(connectURI, userName, password);
    PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory,
            connectionPool, null, null, false, true);
    PoolingDataSource dataSource = new PoolingDataSource(connectionPool);
    return dataSource;
}

---

From source file:com.ec2box.manage.util.DSPool.java

/**
 * register the data source for H2 DB//from ww w.  jav  a 2s  .  c  o m
 *
 * @return pooling database object
 */

private static PoolingDataSource registerDataSource() {

    // create a database connection
    String user = "ec2box";
    String password = "filepwd 0WJLnwhpA47EepT1A4drVnDn3vYRvJhpZi0sVdvN9SmlbKw";
    String connectionURI = "jdbc:h2:" + getDBPath() + "/ec2box;CIPHER=AES;";

    if (StringUtils.isNotEmpty(DB_OPTIONS)) {
        connectionURI = connectionURI + DB_OPTIONS;
    }

    String validationQuery = "select 1";

    try {
        Class.forName("org.h2.Driver");
    } catch (ClassNotFoundException ex) {
        log.error(ex.toString(), ex);
    }

    GenericObjectPool connectionPool = new GenericObjectPool(null);

    connectionPool.setMaxActive(MAX_ACTIVE);
    connectionPool.setTestOnBorrow(TEST_ON_BORROW);
    connectionPool.setMinIdle(MIN_IDLE);
    connectionPool.setMaxWait(MAX_WAIT);
    connectionPool.setWhenExhaustedAction(GenericObjectPool.WHEN_EXHAUSTED_BLOCK);

    ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(connectionURI, user, password);

    new PoolableConnectionFactory(connectionFactory, connectionPool, null, validationQuery, false, true);

    return new PoolingDataSource(connectionPool);

}

---

From source file:com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.DbcpDataSource.java

public DbcpDataSource(ObjectPoolFactory objectPoolFactory, String url, String username, String password,
        boolean defaultReadOnly, boolean defaultAutoCommit) {
    connectionPool = createPool(objectPoolFactory);
    createPoolableConnectionFactory(url, username, password, defaultReadOnly, defaultAutoCommit);

    dataSource = new PoolingDataSource(connectionPool);
    dataSource.setAccessToUnderlyingConnectionAllowed(true);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• »