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

List of usage examples for org.apache.commons.dbcp BasicDataSource BasicDataSource

  1. HOME
  2. Java
  3. org.apache.commons
  4. org.apache.commons.dbcp.*
  5. BasicDataSource
  6. BasicDataSource

Introduction

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

Prototype

BasicDataSource

Source Link

Usage

From source file:org.geotools.referencing.factory.epsg.HsqlDialectEpsgMediatorConnectionLeakTest.java

@Override
protected void setUp() throws Exception {
    super.setUp();
    hints = new Hints(Hints.CACHE_POLICY, "none");
    hints.put(Hints.AUTHORITY_MAX_ACTIVE, Integer.valueOf(MAX_WORKERS));

    final DataSource database = HsqlEpsgDatabase.createDataSource();
    datasource = new BasicDataSource() {
        {// ww w  .j  a  v  a  2  s . co  m
            this.dataSource = database;
        }
    };
    mediator = new HsqlDialectEpsgMediator(80, hints, datasource);
    codes = HsqlDialectEpsgMediatorStressTest.getCodes();
}

From source file:org.geotools.referencing.factory.epsg.OracleDialectEpsgMediatorConnectionLeakOnlineTest.java

protected void connect() throws Exception {
    super.connect();
    hints = new Hints(Hints.CACHE_POLICY, "none");
    hints.put(Hints.AUTHORITY_MAX_ACTIVE, new Integer(MAX_WORKERS));
    if (datasource == null) {
        fail("no datasource available");
    }/*from w  w  w  .  j  a  v  a 2  s. co m*/
    wrappedDataSource = new BasicDataSource() {
        {
            this.dataSource = datasource;
        }
    };
    mediator = new OracleDialectEpsgMediator(80, hints, wrappedDataSource);
    codes = OracleDialectEpsgMediatorOnlineStressTest.getCodes();
}

From source file:org.geotools.referencing.factory.epsg.OracleDialectEpsgMediatorStarvationOnlineStressTest.java

protected DataSource connect(String user, String password, String url, Properties params) throws SQLException {
    //DataSource origional = super.connect( user, password, url, params );

    BasicDataSource origional = new BasicDataSource();
    origional.setDriverClassName("oracle.jdbc.driver.OracleDriver");
    origional.setUsername(user);/*from   ww  w. j av a 2  s. co m*/
    origional.setPassword(password);
    origional.setUrl(url);
    origional.setMaxActive(10);
    origional.setMaxIdle(1);
    return origional;
}

From source file:org.geowebcache.diskquota.jdbc.JDBCQuotaStoreFactory.java

private DataSource getDataSource(JDBCConfiguration config) throws ConfigurationException {
    try {//from w  ww  .j ava2  s .  com
        DataSource ds = null;
        if (config.getJNDISource() != null) {
            InitialContext context = new InitialContext();
            ds = (DataSource) context.lookup(config.getJNDISource());
        } else if (config.getConnectionPool() != null) {
            ConnectionPoolConfiguration cp = config.getConnectionPool();

            BasicDataSource bds = new BasicDataSource();
            bds.setDriverClassName(cp.getDriver());
            bds.setUrl(cp.getUrl());
            bds.setUsername(cp.getUsername());
            bds.setPassword(cp.getPassword());
            bds.setPoolPreparedStatements(true);
            bds.setMaxOpenPreparedStatements(cp.getMaxOpenPreparedStatements());
            bds.setMinIdle(cp.getMinConnections());
            bds.setMaxActive(cp.getMaxConnections());
            bds.setMaxWait(cp.getConnectionTimeout() * 1000);
            bds.setValidationQuery(cp.getValidationQuery());

            ds = bds;
        }

        // verify the datasource works
        Connection c = null;
        try {
            c = ds.getConnection();
        } catch (SQLException e) {
            throw new ConfigurationException("Failed to get a database connection: " + e.getMessage(), e);
        } finally {
            if (c != null) {
                try {
                    c.close();
                } catch (SQLException e) {
                    // nothing we can do about it, but at least let the admin know
                    log.debug("An error occurred while closing the test JDBC connection: " + e.getMessage(), e);
                }
            }
        }

        return ds;
    } catch (NamingException e) {
        throw new ConfigurationException("Failed to locate the data source in JNDI", e);
    }
}

From source file:org.geowebcache.diskquota.jdbc.JDBCQuotaStoreFactory.java

/**
 * Prepares a simple data source for the embedded H2
 * //from   www.  j av  a 2s  . c  o  m
 * @param cacheDirFinder
 * @return
 * @throws ConfigurationException
 */
private DataSource getH2DataSource(DefaultStorageFinder cacheDirFinder) throws ConfigurationException {
    File storeDirectory = new File(cacheDirFinder.getDefaultPath(), "diskquota_page_store_h2");
    storeDirectory.mkdirs();

    BasicDataSource dataSource = new BasicDataSource();

    dataSource.setDriverClassName("org.h2.Driver");
    String database = new File(storeDirectory, "diskquota").getAbsolutePath();
    dataSource.setUrl("jdbc:h2:" + database);
    dataSource.setUsername("sa");
    dataSource.setPoolPreparedStatements(true);
    dataSource.setAccessToUnderlyingConnectionAllowed(true);
    dataSource.setMinIdle(1);
    dataSource.setMaxActive(-1); // boundless
    dataSource.setMaxWait(5000);
    return dataSource;
}

From source file:org.glowroot.agent.plugin.jdbc.Connections.java

static BasicDataSource createCommonsDbcpWrappedDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.hsqldb.jdbc.JDBCDriver");
    ds.setUrl("jdbc:hsqldb:mem:test");
    return ds;/*from  ww w  . jav  a 2 s  .c  o m*/
}

From source file:org.glowroot.plugin.jdbc.Connections.java

private static Connection createCommonsDbcpWrappedConnection() throws SQLException {
    // set up database
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.hsqldb.jdbc.JDBCDriver");
    ds.setUrl("jdbc:hsqldb:mem:test");
    Connection connection = ds.getConnection();
    insertRecords(connection);// w  ww  .ja  v  a 2s .  co  m
    return connection;
}

From source file:org.gogoego.util.db.DBSessionFactory.java

public void connectPool(String name, String url, String driverClass, String username, String password) {

    final BasicDataSource ds = new BasicDataSource() {
        /**//ww w.ja va 2s  .co m
         * DBCP 1.4's implementation is ... unexpected.  You can set a custom
         * classloader, but in fact it won't be used to load the driver.
         * Bug reported on dev@commons list.
         */
        @Override
        protected ConnectionFactory createConnectionFactory() throws SQLException {
            try {
                Driver driver = loadDriver();

                String user = username;
                if (user != null)
                    connectionProperties.put("user", user);

                String pwd = password;
                if (pwd != null)
                    connectionProperties.put("password", pwd);

                ConnectionFactory driverConnectionFactory = new DriverConnectionFactory(driver, url,
                        connectionProperties);
                return driverConnectionFactory;
            } catch (Exception ex) {
                throw new SQLException(ex);
            }
        }
    };

    ds.setDriverClassName(driverClass);
    ds.setUsername(username);
    ds.setPassword(password);
    ds.setUrl(url);
    DBSessionFactory.registerDataSource(name, ds);
}

From source file:org.guzz.connection.DBCPDataSourceProvider.java

public void configure(Properties props, int maxLoad) {
    if (dataSource == null) {
        dataSource = new BasicDataSource();
    }//from w  w  w .  j  ava 2s. com

    JavaBeanWrapper bw = BeanWrapper.createPOJOWrapper(dataSource.getClass());
    Enumeration e = props.keys();
    while (e.hasMoreElements()) {
        String key = (String) e.nextElement();
        String value = props.getProperty(key);

        try {
            bw.setValueAutoConvert(dataSource, key, value);
        } catch (Exception e1) {
            log.error("unkown property:[" + key + "=" + value + "]", e1);
        }
    }

    //?500
    if (maxLoad > 1000 || maxLoad < 1) {
        maxLoad = 500;
    }

    dataSource.setMaxActive(maxLoad);

    //fetch a connection to force the datasource building the pool
    Connection c = null;
    try {
        c = dataSource.getConnection();
    } catch (SQLException e1) {
        log.error(props, e1);
    } finally {
        CloseUtil.close(c);
    }
}

From source file:org.gvsig.fmap.dal.store.jdbc.JDBCResource.java

protected DataSource createDataSource() {
    JDBCResourceParameters jdbcParams = (JDBCResourceParameters) this.getParameters();
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(jdbcParams.getJDBCDriverClassName());
    dataSource.setUsername(jdbcParams.getUser());
    dataSource.setPassword(jdbcParams.getPassword());
    dataSource.setUrl(jdbcParams.getUrl());

    dataSource.setMaxWait(60L * 1000); // FIXME

    // FIXME Set Pool parameters:
    /*//from w  w  w  .  j  a  va2 s  .c om
    dataSource.setMaxActive(maxActive);
    dataSource.setMaxIdle(maxActive);
    dataSource.setMaxOpenPreparedStatements(maxActive);
    dataSource.setMaxWait(maxActive);
    dataSource.setInitialSize(initialSize);
    dataSource.setDefaultReadOnly(defaultReadOnly);
    dataSource.setDefaultTransactionIsolation(defaultTransactionIsolation);
    dataSource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
    dataSource.setMinIdle(minIdle);
    dataSource.setTestOnBorrow(testOnBorrow);
    dataSource.setTestOnReturn(testOnReturn);
    dataSource.setTestWhileIdle(testOnReturn);
    dataSource
       .setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
            
    dataSource.setAccessToUnderlyingConnectionAllowed(allow);
    dataSource.setLoginTimeout(seconds);
    dataSource.setLogWriter(out);
     */
    return dataSource;
}