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

Introduction

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

Prototype

public synchronized void setUrl(String url)

Source Link

Document

Sets the #url .

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

Usage

From source file:com.alibaba.druid.pool.dbcp.Test0.java

public void test_idle() throws Exception {
    MockDriver driver = MockDriver.instance;

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl("jdbc:mock:xxx");
    dataSource.setDriverClassName("com.alibaba.druid.mock.MockDriver");
    dataSource.setInitialSize(0);/* ww w.ja  va  2 s .  c o m*/
    dataSource.setMaxActive(4);
    dataSource.setMaxIdle(4);
    dataSource.setMinIdle(1);
    dataSource.setMinEvictableIdleTimeMillis(5000 * 1);
    dataSource.setTimeBetweenEvictionRunsMillis(10);
    dataSource.setTestWhileIdle(false);
    dataSource.setTestOnBorrow(false);
    dataSource.setValidationQuery("SELECT 1");

    {
        Connection conn = dataSource.getConnection();

        // Assert.assertEquals(dataSource.getInitialSize(), driver.getConnections().size());
        System.out.println("raw size : " + driver.getConnections().size());

        conn.close();
        System.out.println("raw size : " + driver.getConnections().size());
    }

    {
        Connection conn = dataSource.getConnection();

        // Assert.assertEquals(dataSource.getInitialSize(), driver.getConnections().size());
        System.out.println("raw size : " + driver.getConnections().size());

        conn.close();
        System.out.println("raw size : " + driver.getConnections().size());
    }

    dataSource.close();
}

From source file:br.com.shopcarpet.test.db.TestConnectDataBase.java

private DataSource getConnection() {
    final BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUrl("jdbc:mysql://localhost/carpet");
    ds.setUsername("carpet");
    ds.setPassword("carpet123");
    return ds;/*from w w  w .  j  a  v  a 2  s  .  c o  m*/
}

From source file:com.spankr.tutorial.ConnectionDAO.java

/**
 * Git me mah datasource!//from   ww  w  . j av a  2s. co  m
 * 
 * @return datasource pointing at the DEV version of partsearch
 */
public DataSource getDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.hsqldb.jdbc.JDBCDriver");
    ds.setUrl("jdbc:hsqldb:mem:sampleDB");
    ds.setUsername("SA");
    ds.setPassword("");
    ds.setInitialSize(2);
    ds.setMaxActive(20);
    return ds;
}

From source file:com.bt.aloha.sipstone.MaintenanceDao.java

public MaintenanceDao(String driver, String url, String uname, String pwd) {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(driver);/*from w w w. j  a v a2s  .  c om*/
    ds.setUrl(url);
    ds.setUsername(uname);
    ds.setPassword(pwd);
    this.jdbcTemplate = new JdbcTemplate(ds);
    testConnection();
}

From source file:net.firejack.platform.core.config.installer.database.MySqlDatabaseManager.java

private DataSource getCreatableDataSource(Database database) {
    String databaseUrl = database.getRdbms().getDbSchemaUrlConnection(database.getProtocol(),
            database.getServerName(), database.getPort().toString(), "mysql");
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl(databaseUrl);
    dataSource.setUsername(database.getUsername());
    dataSource.setPassword(database.getPassword());
    return dataSource;
}

From source file:com.apress.prospringintegration.batch.JdbcConfiguration.java

@Bean(destroyMethod = "close")
public BasicDataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driverClassName);
    dataSource.setUrl(url);
    dataSource.setUsername(username);//from   w  w w.  ja  v a2s .  c  om
    dataSource.setPassword(password);
    return dataSource;
}

From source file:com.emc.ecs.sync.service.MySQLDbService.java

@Override
protected JdbcTemplate createJdbcTemplate() {
    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(connectString);
    ds.addConnectionProperty("characterEncoding", "UTF-8");
    if (username != null)
        ds.setUsername(username);//from   w  w  w. j a  v  a 2 s  . c o  m
    if (password != null)
        ds.setPassword(password);
    ds.setMaxActive(1000);
    ds.setMaxIdle(1000);
    ds.setMaxOpenPreparedStatements(1000);
    ds.setPoolPreparedStatements(true);
    return new JdbcTemplate(ds);
}

From source file:com.example.dbflute.spring.JdbcBeansJavaConfig.java

@Bean(name = { "dataSource" })
public DataSource createDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.h2.Driver");
    ds.setUrl(exampleDbUrl);
    ds.setUsername("sa");
    ds.setPassword("");
    ds.setMaxActive(20);/* ww  w.j  a  v  a  2  s .  co  m*/
    return ds;
}

From source file:com.open.license.config.ContextConfig.java

@Bean
public DataSource dataSource() {
    log.info("[START:Set DataSource]");
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setUrl(DATASOURCE_URL);
    basicDataSource.setUsername(DATABASE_USERNAME);
    basicDataSource.setPassword(DATABASE_PASSWORD);
    log.info("[END:Set DataSource]");
    return basicDataSource;

}

From source file:com.mycompany.geocoordinate.config.DataConfig.java

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

    return dataSource;

}