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

Introduction

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

Prototype

public synchronized void setUsername(String username)

Source Link

Document

Sets the #username .

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

Usage

From source file:io.apiman.gateway.engine.impl.DefaultJdbcComponentTest.java

@Test
public void testDataSource() throws Throwable {
    DefaultJdbcComponent component = new DefaultJdbcComponent();

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(Driver.class.getName());
    ds.setUsername("sa");
    ds.setPassword("");
    ds.setUrl("jdbc:h2:mem:testDataSource;DB_CLOSE_DELAY=-1");

    try {/* w  w w . j a v a  2  s .  co  m*/
        IJdbcClient client = component.create(ds);
        doAllTests(client);
    } finally {
        try {
            ds.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

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

public MaintenanceDao() throws Exception {
    InputStream is = Thread.currentThread().getContextClassLoader().getResourceAsStream("sip.properties");
    Properties dbProps = new Properties();
    dbProps.load(is);//from ww w  .j av a  2s  .c  o  m
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(dbProps.getProperty("database.driverClassName", "org.postgresql.Driver"));
    ds.setUrl(dbProps.getProperty("database.url", "jdbc:postgresql://localhost:5432/springring"));
    ds.setUsername(dbProps.getProperty("database.username", "springringuser"));
    ds.setPassword(dbProps.getProperty("database.password", "springringuser"));
    this.jdbcTemplate = new JdbcTemplate(ds);
}

From source file:com.dangdang.ddframe.rdb.integrate.AbstractDBUnitTest.java

private DataSource createDataSource(final String dataSetFile) {
    if (DATA_SOURCES.containsKey(dataSetFile)) {
        return DATA_SOURCES.get(dataSetFile);
    }//www .  ja va2 s .co m
    BasicDataSource result = new BasicDataSource();
    result.setDriverClassName(dbEnv.getDriverClassName());
    result.setUrl(dbEnv.getURL(getFileName(dataSetFile)));
    result.setUsername(dbEnv.getUsername());
    result.setPassword(dbEnv.getPassword());
    result.setMaxActive(1000);
    DATA_SOURCES.put(dataSetFile, result);
    return result;
}

From source file:io.druid.db.DbConnector.java

private DataSource getDatasource() {
    DbConnectorConfig connectorConfig = config.get();

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUsername(connectorConfig.getUser());
    dataSource.setPassword(connectorConfig.getPassword());
    String uri = connectorConfig.getConnectURI();
    isPostgreSQL = uri.startsWith("jdbc:postgresql");
    dataSource.setUrl(uri);/* w ww .j  av  a2s  . c  o  m*/

    if (connectorConfig.isUseValidationQuery()) {
        dataSource.setValidationQuery(connectorConfig.getValidationQuery());
        dataSource.setTestOnBorrow(true);
    }

    return dataSource;
}

From source file:cn.vlabs.umt.common.datasource.DatabaseUtil.java

public DatabaseUtil(Config config) {
    BasicDataSource ds = new BasicDataSource();

    ds.setMaxActive(config.getInt("database.maxconn", 10));
    ds.setMaxIdle(config.getInt("database.maxidle", 3));
    ds.setMaxWait(100);//from www  . j  av a2s .c  o m

    ds.setUsername(config.getStringProp("database.username", null));
    ds.setPassword(config.getStringProp("database.password", null));
    ds.setDriverClassName(config.getStringProp("database.driver", null));
    ds.setUrl(config.getStringProp("database.conn-url", null));
    ds.setTimeBetweenEvictionRunsMillis(3600000);
    ds.setMinEvictableIdleTimeMillis(1200000);
    datasource = ds;
}

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);
}

From source file:com.dangdang.ddframe.job.lite.console.restful.EventTraceHistoryRestfulApi.java

private DataSource setUpEventTraceDataSource() {
    BasicDataSource result = new BasicDataSource();
    result.setDriverClassName(eventTraceDataSourceConfiguration.getDriver());
    result.setUrl(eventTraceDataSourceConfiguration.getUrl());
    result.setUsername(eventTraceDataSourceConfiguration.getUsername());
    result.setPassword(eventTraceDataSourceConfiguration.getPassword());
    return result;
}

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:net.hydromatic.optiq.test.JdbcTest.java

/**
 * Creates a connection with a given query provider. If provider is null,
 * uses the connection as its own provider. The connection contains a
 * schema called "foodmart" backed by a JDBC connection to MySQL.
 *
 * @param queryProvider Query provider/*from  w  ww. j  a  va 2 s . c om*/
 * @param withClone Whether to create a "foodmart2" schema as in-memory
 *     clone
 * @return Connection
 * @throws ClassNotFoundException
 * @throws SQLException
 */
static OptiqConnection getConnection(QueryProvider queryProvider, boolean withClone)
        throws ClassNotFoundException, SQLException {
    Class.forName("net.hydromatic.optiq.jdbc.Driver");
    Class.forName("com.mysql.jdbc.Driver");
    Connection connection = DriverManager.getConnection("jdbc:optiq:");
    OptiqConnection optiqConnection = connection.unwrap(OptiqConnection.class);
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl("jdbc:mysql://localhost");
    dataSource.setUsername("foodmart");
    dataSource.setPassword("foodmart");

    JdbcSchema foodmart = JdbcSchema.create(optiqConnection.getRootSchema(), dataSource, "foodmart", null,
            "foodmart");
    if (withClone) {
        CloneSchema.create(optiqConnection.getRootSchema(), "foodmart2", foodmart);
    }
    optiqConnection.setSchema("foodmart2");
    return optiqConnection;
}