Example usage for org.apache.commons.dbcp2.cpdsadapter DriverAdapterCPDS setUrl

List of usage examples for org.apache.commons.dbcp2.cpdsadapter DriverAdapterCPDS setUrl

Introduction

In this page you can find the example usage for org.apache.commons.dbcp2.cpdsadapter DriverAdapterCPDS setUrl.

Prototype

public void setUrl(String v) 

Source Link

Document

Set the value of url used to locate the database for this datasource.

Usage

From source file:com.smartmarmot.dbforbix.db.adapter.AbstractDBAdapter.java

private void createConnection() throws SQLException, ClassNotFoundException {
    LOG.info("Creating new connection pool for database " + getName());
    Config cfg = Config.getInstance();//from w  ww.j av a 2  s  . c  o  m
    DriverAdapterCPDS cpds = new DriverAdapterCPDS();
    cpds.setDriver(getType().getJDBCDriverClass());
    cpds.setUrl(getURL());
    cpds.setUser(getUser());
    cpds.setPassword(getPassword());
    datasrc = new SharedPoolDataSource();
    datasrc.setConnectionPoolDataSource(cpds);
    datasrc.setLoginTimeout(cfg.getLoginTimeout());
    datasrc.setMaxTotal(getMaxActive());
    datasrc.setDefaultMaxIdle(getMaxIdle());
    datasrc.setDefaultMaxWaitMillis(getMaxWaitMillis());
    datasrc.setValidationQuery(getType().getAliveSQL());
    datasrc.setDefaultTestOnBorrow(true);
    /**
     * wait while connection is initialized
     */
    try {
        Thread.sleep(1000);
    } catch (InterruptedException e) {
        e.printStackTrace();
    }
}

From source file:org.lightmare.jpa.datasource.dbcp.InitDBCP.java

@Override
public DataSource initializeDataSource() throws IOException {

    String jndiName = Initializer.getJndiName(properties);

    DriverAdapterCPDS dacp = new DriverAdapterCPDS();

    try {/* w w  w . j  ava 2 s .  c  om*/
        dacp.setDriver(driver);
    } catch (ClassNotFoundException ex) {
        throw new IOException(ex);
    }
    dacp.setUrl(url);
    dacp.setUser(user);
    dacp.setPassword(password);

    SharedPoolDataSource dataSource = new SharedPoolDataSource();
    dataSource.setDataSourceName(jndiName);
    dataSource.setDefaultAutoCommit(Boolean.FALSE);
    dataSource.setDefaultReadOnly(Boolean.FALSE);
    dataSource.setDefaultTransactionIsolation(DEFAULT_TRANSACTION_ISOLATION);
    dataSource.setLoginTimeout(PoolConfig.asInt(properties, PoolConfig.Defaults.MAX_IDLE_TIMEOUT));
    dataSource.setDefaultMaxTotal(PoolConfig.asInt(properties, PoolConfig.Defaults.MAX_POOL_SIZE));
    dataSource.setDefaultMaxIdle(PoolConfig.asInt(properties, PoolConfig.Defaults.MAX_IDLE_TIMEOUT));
    dataSource.setDefaultMaxWaitMillis(PoolConfig.asInt(properties, PoolConfig.Defaults.CHECK_OUT_TIMEOUT));

    return dataSource;
}