Example usage for org.apache.commons.dbcp2 BasicDataSource setDriverClassName

Introduction

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

Prototype

public synchronized void setDriverClassName(String driverClassName)

Source Link

Document

Sets the jdbc driver class name.

Note: this method currently has no effect once the pool has been initialized.

Usage

From source file:io.druid.server.namespace.cache.JDBCExtractionNamespaceTest.java

@BeforeClass
public static final void createTables() {
    final BasicDataSource datasource = new BasicDataSource();
    datasource.setUrl(connectionURI);//  w  w w  .ja va2  s  .  co  m
    datasource.setDriverClassLoader(JDBCExtractionNamespaceTest.class.getClassLoader());
    datasource.setDriverClassName("org.apache.derby.jdbc.EmbeddedDriver");
    dbi = new DBI(datasource);
    dbi.withHandle(new HandleCallback<Void>() {
        @Override
        public Void withHandle(Handle handle) throws Exception {
            handle.createStatement(
                    String.format("CREATE TABLE %s (%s TIMESTAMP, %s VARCHAR(64), %s VARCHAR(64))", tableName,
                            tsColumn_, keyName, valName))
                    .execute();
            return null;
        }
    });
}

From source file:de.rwth.dbis.acis.activitytracker.service.ActivityTrackerService.java

private static DataSource setupDataSource(String dbUrl, String dbUserName, String dbPassword) {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl(dbUrl);/*from w w  w  .  j  ava  2  s . c om*/
    dataSource.setUsername(dbUserName);
    dataSource.setPassword(dbPassword);
    dataSource.setValidationQuery("SELECT 1;");
    dataSource.setTestOnBorrow(true); // test each connection when borrowing from the pool with the validation query
    dataSource.setMaxConnLifetimeMillis(1000 * 60 * 60); // max connection life time 1h. mysql drops connection after 8h.
    return dataSource;
}

From source file:com.quick.config.JDBCConfig.java

@Bean
@Override/*w  ww . j  ava 2  s.co m*/
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(org.hsqldb.jdbcDriver.class.getName());
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    dataSource.setUrl("jdbc:hsqldb:mem:mydb");
    return dataSource;
}

From source file:com.searchcode.app.config.DatabaseConfig.java

public Connection getConnection() throws SQLException {
    BasicDataSource ds = new BasicDataSource(); // pooling data source

    ds.setDriverClassName("org.hsqldb.jdbcDriver");
    ds.setUsername("sa");
    ds.setPassword("");
    ds.setUrl("jdbc:hsqldb:file:searchcode;shutdown=true");

    return ds.getConnection();
}

From source file:com.tamnd.app.config.DataSourceConfig.java

@Bean
public DataSource h2DataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.h2.Driver");
    dataSource.setUrl("jdbc:h2:mem:test");
    dataSource.setUsername("sa");
    dataSource.setPassword("sa");
    return dataSource;
}

From source file:cz.muni.fi.BicycleRental.SpringConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName("org.apache.derby.jdbc.ClientDriver");
    bds.setUrl(dbUrl);//  w ww .  j a  va2  s  .  co m
    return bds;
}

From source file:com.tamnd.app.config.DataSourceConfig.java

@Bean
public DataSource mysqlDataSource() {
    String _user = "root";
    String _password = "123456";
    String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&maxReconnects=10&";

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl(url);/*from   w ww .j  a  v a 2 s  .  com*/
    dataSource.setUsername(_user);
    dataSource.setPassword(_password);
    return dataSource;
}

From source file:cz.fi.muni.pv168.SpringConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName(env.getProperty("jdbc.driver"));
    bds.setUrl(env.getProperty("jdbc.url"));
    bds.setUsername(env.getProperty("jdbc.user"));
    bds.setPassword(env.getProperty("jdbc.password"));
    return bds;/* w w  w .j  ava2 s .c  o m*/
}

From source file:edu.neu.webtoolsfinal.config.RepositoryConfiguration.java

@Bean(name = "dataSource")
public DataSource getDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/deliverydb");
    dataSource.setUsername("root");
    dataSource.setPassword("");

    return dataSource;
}

From source file:com.samovich.service.blueprint.App.java

/**
 * Data source configuration with dbcp/*www . j a  va  2  s  .  co m*/
 * @return dataSource
 */
@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://HOST:PORT/DATABASE_NAME");
    dataSource.setUsername("DB_USER");
    dataSource.setPassword("RB_PW");
    dataSource.setValidationQuery("select 1");
    dataSource.setMaxTotal(50);
    dataSource.setTestOnBorrow(true);
    dataSource.setMaxWaitMillis(10000);
    dataSource.setRemoveAbandonedOnBorrow(true);
    dataSource.setDefaultAutoCommit(false);
    dataSource.setNumTestsPerEvictionRun(3);
    dataSource.setTimeBetweenEvictionRunsMillis(1800000);
    dataSource.setMinEvictableIdleTimeMillis(1800000);
    return dataSource;
}