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.abixen.platform.module.configuration.PlatformModuleDataSourceConfiguration.java

@Profile("cloud")
@Bean(destroyMethod = "close")
public DataSource cloudDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driverClassName);
    dataSource.setUrl(databaseUrl);
    dataSource.setUsername(username);/*from  w  w  w.  ja  v a  2s . co  m*/
    dataSource.setPassword(password);
    return dataSource;
}

From source file:com.alibaba.druid.pool.bonecp.TestLRU.java

public void f_test_dbcp() throws Exception {
    BasicDataSource ds = new BasicDataSource();
    ds.setUrl("jdbc:mock:test");
    ds.setMaxIdle(10);/*from w w  w . jav a2 s.  com*/

    for (int i = 0; i < 10; ++i) {
        f(ds, 5);
        System.out.println("--------------------------------------------");
    }
}

From source file:com.abixen.platform.module.configuration.PlatformModuleDataSourceConfiguration.java

@Profile("test")
@Bean(destroyMethod = "close")
public DataSource testDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(driverClassName);
    dataSource.setUrl(databaseUrl);
    dataSource.setUsername(username);//  w w w . ja va2 s.co m
    dataSource.setPassword(password);
    // DatabasePopulatorUtils.execute(databasePopulator(), dataSource);
    return dataSource;
}

From source file:com.alibaba.druid.pool.bonecp.TestPSCache.java

public void f_test_dbcp() throws Exception {
    BasicDataSource ds = new BasicDataSource();
    ds.setUrl("jdbc:mock:test");
    ds.setMaxIdle(10);/*from  w w  w  . j a v  a  2  s. co m*/
    ds.setPoolPreparedStatements(true);
    ds.setMaxOpenPreparedStatements(10);

    for (int i = 0; i < 10; ++i) {
        f(ds, 5);
        System.out.println("--------------------------------------------");
    }
}

From source file:gestores.PoolDeConexiones.java

protected void pedirConexion() throws Exception {
    if (conexion == null) {
        try {//from   w w w .  j a  v a  2s.c  o m
            BasicDataSource basicDataSource = new BasicDataSource();
            basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
            basicDataSource.setUrl("jdbc:mysql://localhost:3306/osg");
            basicDataSource.setUsername("root");
            basicDataSource.setPassword("root");
            basicDataSource.setMaxActive(20);
            basicDataSource.setMaxIdle(2);
            conexion = basicDataSource.getConnection();
            conexion.setAutoCommit(false);
        } catch (SQLException e) {
            throw new Exception(e.getMessage());
        }
    }
}

From source file:com.dangdang.ddframe.rdb.sharding.spring.AbstractSpringDBUnitTest.java

private DataSource createDataSource(final String dataSetFile) {
    BasicDataSource result = new BasicDataSource();
    result.setDriverClassName(org.h2.Driver.class.getName());
    result.setUrl(String.format("jdbc:h2:mem:%s;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL",
            getFileName(dataSetFile)));//  w w  w  .  j  ava 2s .c  o  m
    result.setUsername("sa");
    result.setPassword("");
    result.setMaxActive(100);
    return result;
}

From source file:jp.classmethod.aws.brian.config.DataSourceConfiguration.java

@Bean
public DataSource dataSource() {
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    basicDataSource.setUrl(url);
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);
    basicDataSource.setValidationQuery("SELECT 1");
    basicDataSource.setMaxActive(50);//  w  ww  .j  a  va 2s . c  o m
    basicDataSource.setMaxIdle(10);
    basicDataSource.setMinIdle(5);
    return basicDataSource;
}

From source file:com.futuretech.config.AppConfig.java

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

    return dataSource;
}

From source file:net.hydromatic.optiq.impl.splunk.SplunkDriver.java

@Override
public Connection connect(String url, Properties info) throws SQLException {
    Connection connection = super.connect(url, info);
    OptiqConnection optiqConnection = (OptiqConnection) connection;
    SplunkConnection splunkConnection;/*from www .ja v  a  2 s  . co m*/
    try {
        String url1 = info.getProperty("url");
        if (url1 == null) {
            throw new IllegalArgumentException("Must specify 'url' property");
        }
        URL url2 = new URL(url1);
        String user = info.getProperty("user");
        if (user == null) {
            throw new IllegalArgumentException("Must specify 'user' property");
        }
        String password = info.getProperty("password");
        if (password == null) {
            throw new IllegalArgumentException("Must specify 'password' property");
        }
        splunkConnection = new SplunkConnection(url2, user, password);
    } catch (Exception e) {
        throw new SQLException("Cannot connect", e);
    }
    final MutableSchema rootSchema = optiqConnection.getRootSchema();
    final String schemaName = "splunk";
    final SplunkSchema schema = new SplunkSchema(optiqConnection, rootSchema, schemaName, splunkConnection,
            optiqConnection.getTypeFactory(), rootSchema.getSubSchemaExpression(schemaName, Schema.class));
    rootSchema.addSchema(schemaName, schema);

    // Include a schema called "mysql" in every splunk connection.
    // This is a hack for demo purposes. TODO: Add a config file mechanism.
    if (true) {
        final String mysqlSchemaName = "mysql";
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            throw new SQLException(e);
        }
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setUrl("jdbc:mysql://localhost");
        dataSource.setUsername("foodmart");
        dataSource.setPassword("foodmart");

        JdbcSchema.create(optiqConnection.getRootSchema(), dataSource, "foodmart", "", mysqlSchemaName);
    }

    return connection;
}

From source file:com.cput.my.wonder.app.config.ConnectionConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource ds = new org.apache.commons.dbcp.BasicDataSource();
    ds.setDriverClassName("org.apache.derby.jdbc.ClientDriver");
    ds.setUrl("jdbc:derby://localhost:1527/AnimalCare");
    ds.setUsername("animal");
    ds.setPassword("animal");
    return ds;/*from ww  w  .  j ava2 s.  co  m*/
}