List of usage examples for org.apache.commons.dbcp2 BasicDataSource setPassword
public void setPassword(String password)
Sets the #password .
Note: this method currently has no effect once the pool has been initialized.
From source file:com.gondor.config.ApplicationContextConfig.java
@Bean(name = "dataSource") public DataSource getDataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl("jdbc:mysql://localhost:3306/usersdb"); dataSource.setUsername("root"); dataSource.setPassword("root"); return dataSource; }
From source file:com.zaxxer.hikari.benchmark.BenchBase.java
private void setupDBCP2basic() throws SQLException { BasicDataSource ds = new BasicDataSource(); ds.setDriverClassName(dbDriver);//from w w w. j a v a 2 s . c o m ds.setUsername("sa"); ds.setPassword(""); ds.setUrl(jdbcURL); ds.setMaxTotal(maxPoolSize); ds.setDefaultAutoCommit(false); ds.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); ds.getConnection().createStatement().execute("CREATE TABLE IF NOT EXISTS test (column varchar);"); DS = ds; }
From source file:com.ebay.pulsar.analytics.dao.RDBMS.java
private boolean init(boolean force) { if (dataSource == null || force) { final BasicDataSource dataSource = new BasicDataSource(); dataSource.setUsername(userName); dataSource.setPassword(userPwd); dataSource.setUrl(url);/*from w ww. j a v a2 s. com*/ dataSource.setTestOnBorrow(true); if (validationQuery != null) dataSource.setValidationQuery(validationQuery); dataSource.setDriverClassLoader(Thread.currentThread().getContextClassLoader()); dataSource.setDriverClassName(driver); this.setDataSource(dataSource); } return true; }
From source file:com.dsf.dbxtract.cdc.AppJournalDeleteTest.java
/** * Rigourous Test :-)/*from www . j a va 2 s .co m*/ * * @throws Exception * in case of any error */ @Test(timeOut = 120000) public void testAppWithJournalDelete() throws Exception { final Config config = new Config(configFile); BasicDataSource ds = new BasicDataSource(); Source source = config.getDataSources().getSources().get(0); ds.setDriverClassName(source.getDriver()); ds.setUsername(source.getUser()); ds.setPassword(source.getPassword()); ds.setUrl(source.getConnection()); // prepara os dados Connection conn = ds.getConnection(); conn.createStatement().execute("truncate table test"); conn.createStatement().execute("truncate table j$test"); // Carrega os dados de origem PreparedStatement ps = conn.prepareStatement("insert into test (key1,key2,data) values (?,?,?)"); for (int i = 0; i < TEST_SIZE; i++) { if ((i % 100) == 0) { ps.executeBatch(); } ps.setInt(1, i); ps.setInt(2, i); ps.setInt(3, (int) Math.random() * 500); ps.addBatch(); } ps.executeBatch(); ps.close(); app = new App(config); app.start(); Assert.assertEquals(config.getHandlers().iterator().next().getStrategy(), JournalStrategy.DELETE); // Popula as tabelas de journal ps = conn.prepareStatement("insert into j$test (key1,key2) values (?,?)"); for (int i = 0; i < TEST_SIZE; i++) { if ((i % 500) == 0) { ps.executeBatch(); } ps.setInt(1, i); ps.setInt(2, i); ps.addBatch(); } ps.executeBatch(); ps.close(); while (true) { TimeUnit.MILLISECONDS.sleep(500); ResultSet rs = conn.createStatement().executeQuery("select count(*) from j$test"); if (rs.next()) { long count = rs.getLong(1); System.out.println("remaining journal rows: " + count); rs.close(); if (count == 0L) break; } } conn.close(); ds.close(); }
From source file:com.greendot.db.jpa.configuration.JpaDatabaseConfiguration.java
@Bean public DataSource dataSource() { final BasicDataSource dataSource = new org.apache.commons.dbcp2.BasicDataSource(); dataSource.setDriverClassName(environment.getProperty("db.datasource.driver")); dataSource.setUrl(environment.getProperty("db.datasource.url")); dataSource.setUsername(environment.getProperty("db.datasource.username")); dataSource.setPassword(environment.getProperty("db.datasource.password")); return dataSource; }
From source file:com.jf.javafx.services.Database.java
public DataSource getDataSource(String jndiName) { DBInfo i = infos.get(jndiName);// w w w . j av a2 s .c o m if (i == null) { return null; } DataSource ds = dss.get(jndiName); if (ds == null) { BasicDataSource t = new BasicDataSource(); t.setDriverClassName(i.dsProvider); t.setUrl(i.dbUrl); if (!i.dbUsername.isEmpty()) t.setUsername(i.dbUsername); if (!i.dbPassword.isEmpty()) t.setPassword(i.dbPassword); ds = t; dss.put(jndiName, ds); } return ds; }
From source file:com.searchbox.framework.config.DataConfiguration.java
@Bean public DataSource dataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_DRIVER)); dataSource.setUrl(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_URL)); dataSource.setUsername(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_USERNAME)); dataSource.setPassword(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_PASSWORD)); return dataSource; }
From source file:com.thoughtworks.go.server.service.BackupServiceH2IntegrationTest.java
private BasicDataSource constructTestDataSource(File file) { BasicDataSource source = new BasicDataSource(); source.setDriverClassName("org.h2.Driver"); source.setUrl("jdbc:h2:" + file.getAbsolutePath() + "/cruise;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE"); source.setUsername("sa"); source.setPassword(""); source.setMaxTotal(32);/*from ww w .j a v a2s . co m*/ source.setMaxIdle(32); return source; }
From source file:io.druid.metadata.SQLMetadataConnector.java
protected BasicDataSource getDatasource() { MetadataStorageConnectorConfig connectorConfig = getConfig(); BasicDataSource dataSource = new BasicDataSource(); dataSource.setUsername(connectorConfig.getUser()); dataSource.setPassword(connectorConfig.getPassword()); String uri = connectorConfig.getConnectURI(); dataSource.setUrl(uri);/*w w w. ja v a 2s . co m*/ dataSource.setValidationQuery(getValidationQuery()); dataSource.setTestOnBorrow(true); return dataSource; }
From source file:com.dsf.dbxtract.cdc.AppJournalWindowTest.java
/** * Rigourous Test :-)//from w ww . ja va 2s .c o m * * @throws Exception * in case of any error */ @Test(dependsOnMethods = "setUp", timeOut = 120000) public void testAppWithJournalWindow() throws Exception { final Config config = new Config(configFile); BasicDataSource ds = new BasicDataSource(); Source source = config.getDataSources().getSources().get(0); ds.setDriverClassName(source.getDriver()); ds.setUsername(source.getUser()); ds.setPassword(source.getPassword()); ds.setUrl(source.getConnection()); // prepara os dados Connection conn = ds.getConnection(); conn.createStatement().execute("truncate table test"); conn.createStatement().execute("truncate table j$test"); // Carrega os dados de origem PreparedStatement ps = conn.prepareStatement("insert into test (key1,key2,data) values (?,?,?)"); for (int i = 0; i < TEST_SIZE; i++) { if ((i % 100) == 0) { ps.executeBatch(); } ps.setInt(1, i); ps.setInt(2, i); ps.setInt(3, (int) Math.random() * 500); ps.addBatch(); } ps.executeBatch(); ps.close(); // Popula as tabelas de journal ps = conn.prepareStatement("insert into j$test (key1,key2) values (?,?)"); for (int i = 0; i < TEST_SIZE; i++) { if ((i % 500) == 0) { ps.executeBatch(); } ps.setInt(1, i); ps.setInt(2, i); ps.addBatch(); } ps.executeBatch(); ps.close(); Long maxWindowId = 0L; ResultSet rs = conn.createStatement().executeQuery("select max(window_id) from j$test"); if (rs.next()) { maxWindowId = rs.getLong(1); System.out.println("maximum window_id loaded: " + maxWindowId); } rs.close(); conn.close(); ds.close(); // Clear any previous test String zkKey = "/dbxtract/cdc/" + source.getName() + "/J$TEST/lastWindowId"; if (client.checkExists().forPath(zkKey) != null) client.delete().forPath(zkKey); // starts monitor Monitor.getInstance(config); // start app app = new App(config); System.out.println(config.toString()); app.start(); Assert.assertEquals(config.getHandlers().iterator().next().getStrategy(), JournalStrategy.WINDOW); while (true) { TimeUnit.MILLISECONDS.sleep(500); try { Long lastWindowId = Long.parseLong(new String(client.getData().forPath(zkKey))); System.out.println("lastWindowId = " + lastWindowId); if (maxWindowId.longValue() == lastWindowId.longValue()) { System.out.println("expected window_id reached"); break; } } catch (NoNodeException nne) { System.out.println("ZooKeeper - no node exception :: " + zkKey); } } }