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

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

Introduction

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

Prototype

public synchronized void setPassword(String password) 

Source Link

Document

Sets the #password .

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

Usage

From source file:com.abixen.platform.core.configuration.PlatformDataSourceConfiguration.java

@Profile(PlatformProfiles.TEST)
@Bean(destroyMethod = "close")
public DataSource testDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(platformJdbcConfiguration.getDriverClassName());
    dataSource.setUrl(platformJdbcConfiguration.getDatabaseUrl());
    dataSource.setUsername(platformJdbcConfiguration.getUsername());
    dataSource.setPassword(platformJdbcConfiguration.getPassword());
    // DatabasePopulatorUtils.execute(databasePopulator(), dataSource);
    return dataSource;
}

From source file:com.abixen.platform.core.configuration.PlatformDataSourceConfiguration.java

@Profile(PlatformProfiles.DEV)
@Bean(destroyMethod = "close")
public DataSource devDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(platformJdbcConfiguration.getDriverClassName());
    dataSource.setUrl(platformJdbcConfiguration.getDatabaseUrl());
    dataSource.setUsername(platformJdbcConfiguration.getUsername());
    dataSource.setPassword(platformJdbcConfiguration.getPassword());
    //DatabasePopulatorUtils.execute(databasePopulator(), dataSource);
    return dataSource;
    //DataSource dataSource = new EmbeddedDatabaseBuilder().setType(EmbeddedDatabaseType.H2).setName("devDataBase").build();
    //return dataSource;
}

From source file:$.DataSourceConf.java

@Bean
    public DataSource dataSource() {
        final BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName(driverClassName);
        dataSource.setUrl(url);/*from   ww w.  j  av  a  2 s  . c  o m*/
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        dataSource.setValidationQuery(validationQuery);
        dataSource.setMaxActive(maxActive);
        dataSource.setMaxIdle(maxIdle);
        dataSource.setMaxWait(maxWait);
        dataSource.setTestOnBorrow(testOnBorrow);
        dataSource.setTestWhileIdle(testWhileIdle);
        dataSource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
        dataSource.setNumTestsPerEvictionRun(numTestsPerEvictionRun);
        dataSource.setRemoveAbandoned(removeAbandoned);
        dataSource.setRemoveAbandonedTimeout(removeAbandonedTimeout);
        dataSource.setLogAbandoned(logAbandoned);
        return dataSource;
    }

From source file:com.consol.citrus.samples.todolist.dao.JdbcApplicationConfig.java

@Bean(destroyMethod = "close")
@DependsOn("database")
public BasicDataSource dataSource(JdbcConfigurationProperties configurationProperties) {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(configurationProperties.getDriverClassName());
    dataSource.setUrl(configurationProperties.getUrl());
    dataSource.setUsername(configurationProperties.getUsername());
    dataSource.setPassword(configurationProperties.getPassword());

    return dataSource;
}

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

@Override
protected JdbcTemplate createJdbcTemplate() {
    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(connectString);//  w  w w  .  j  ava  2 s. c  om
    ds.addConnectionProperty("characterEncoding", "UTF-8");
    if (username != null)
        ds.setUsername(username);
    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:io.pivotal.spring.xd.jdbcgpfdist.support.GreenplumDataSourceFactoryBean.java

@Override
protected BasicDataSource createInstance() throws Exception {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.postgresql.Driver");
    if (StringUtils.hasText(dbUser)) {
        ds.setUsername(dbUser);/*from  w ww . j  a v  a  2s  . co m*/
    }
    if (StringUtils.hasText(dbPassword)) {
        ds.setPassword(dbPassword);
    }
    ds.setUrl("jdbc:postgresql://" + dbHost + ":" + dbPort + "/" + dbName);
    return ds;
}

From source file:gobblin.metastore.MysqlStateStore.java

/**
 * creates a new {@link BasicDataSource}
 * @param config the properties used for datasource instantiation
 * @return/*from  ww  w  . ja v  a 2 s  .  co m*/
 */
public static BasicDataSource newDataSource(Config config) {
    BasicDataSource basicDataSource = new BasicDataSource();
    PasswordManager passwordManager = PasswordManager.getInstance(ConfigUtils.configToProperties(config));

    basicDataSource
            .setDriverClassName(ConfigUtils.getString(config, ConfigurationKeys.STATE_STORE_DB_JDBC_DRIVER_KEY,
                    ConfigurationKeys.DEFAULT_STATE_STORE_DB_JDBC_DRIVER));
    // MySQL server can timeout a connection so need to validate connections before use
    basicDataSource.setValidationQuery("select 1");
    basicDataSource.setTestOnBorrow(true);
    basicDataSource.setDefaultAutoCommit(false);
    basicDataSource.setTimeBetweenEvictionRunsMillis(60000);
    basicDataSource.setUrl(config.getString(ConfigurationKeys.STATE_STORE_DB_URL_KEY));
    basicDataSource.setUsername(
            passwordManager.readPassword(config.getString(ConfigurationKeys.STATE_STORE_DB_USER_KEY)));
    basicDataSource.setPassword(
            passwordManager.readPassword(config.getString(ConfigurationKeys.STATE_STORE_DB_PASSWORD_KEY)));
    basicDataSource.setMinEvictableIdleTimeMillis(
            ConfigUtils.getLong(config, ConfigurationKeys.STATE_STORE_DB_CONN_MIN_EVICTABLE_IDLE_TIME_KEY,
                    ConfigurationKeys.DEFAULT_STATE_STORE_DB_CONN_MIN_EVICTABLE_IDLE_TIME));

    return basicDataSource;
}

From source file:com.dangdang.ddframe.rdb.sharding.config.yaml.YamlShardingDataSourceTest.java

private DataSource createDataSource() {
    BasicDataSource result = new BasicDataSource();
    result.setDriverClassName(Driver.class.getName());
    result.setUrl("jdbc:h2:mem:%s;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL");
    result.setUsername("sa");
    result.setPassword("");
    return result;
}

From source file:com.consol.citrus.samples.todolist.dao.JdbcTodoListDao.java

private DataSource createDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.hsqldb.jdbcDriver");
    dataSource.setUrl("jdbc:hsqldb:hsql://localhost/testdb");
    dataSource.setUsername("sa");
    dataSource.setPassword("");

    return dataSource;
}

From source file:com.dangdang.ddframe.job.event.rdb.JobEventRdbStorageTest.java

@Before
public void setup() throws SQLException {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(org.h2.Driver.class.getName());
    dataSource.setUrl("jdbc:h2:mem:job_event_storage");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    storage = new JobEventRdbStorage(dataSource);
}