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.ebay.pulsar.analytics.metricstore.db.RDMBSTest.java
@SuppressWarnings("unchecked") @Test/*from w w w . j a v a2 s .c o m*/ public void testRDBMS() { String driver2 = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://locahost:3306/test"; String userName = "root"; String userPwd = ""; BasicDataSource bds = new BasicDataSource(); bds.setDriverClassName(driver2); bds.setUrl(url); bds.setUsername(userName); bds.setPassword(userPwd); DBFactory.setDs(bds); List<String> result = new ArrayList<String>(); result.add("result"); NamedParameterJdbcTemplate namedParameterJdbcTemplate = Mockito.mock(NamedParameterJdbcTemplate.class); when(namedParameterJdbcTemplate.query(Matchers.anyString(), Matchers.any(Map.class), Matchers.any(ResultSetExtractor.class))).thenReturn(result); RDBMS db = new RDBMS(driver2, url, userName, userPwd); db.setDriver(driver2); db.setNamedParameterJdbcTemplate(namedParameterJdbcTemplate); db.setUrl(url); db.setUserName(userName); db.setUserPwd(userPwd); assertEquals(namedParameterJdbcTemplate, db.getNamedParameterJdbcTemplate()); Map<String, String> map = new HashMap<String, String>(); assertTrue(result.equals(db.queryForList("test", map, 10))); }
From source file:com.peertopark.spring.data.SpringDataConfig.java
@Bean public DataSource dataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setUrl(dataSourceConfig.getJDBCUrl()); dataSource.setUsername(dataSourceConfig.getJDBCUser()); dataSource.setPassword(dataSourceConfig.getJDBCPassword()); dataSource.setDriverClassName(dataSourceConfig.getJDBCDriver()); dataSource.setMaxTotal(dataSourceConfig.getMaxConnections()); return dataSource; }
From source file:com.graphaware.importer.data.access.DbDataReader.java
/** * Create a {@link javax.sql.DataSource} used for talking to the database. * * @return data source./*ww w . j a v a 2s. c om*/ */ protected DataSource createDataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setUrl(getUrl(dbHost, dbPort)); dataSource.setUsername(user); dataSource.setPassword(password); dataSource.setDefaultReadOnly(true); dataSource.setDefaultAutoCommit(false); dataSource.setDriverClassName(getDriverClassName()); additionalConfig(dataSource); return dataSource; }
From source file:cz.fi.muni.pv168.SpringConfig.java
@Bean public DataSource dataSource() { BasicDataSource bds = new BasicDataSource(); bds.setDriverClassName(env.getProperty("jdbc.driver")); bds.setUrl(env.getProperty("jdbc.url")); bds.setUsername(env.getProperty("jdbc.user")); bds.setPassword(env.getProperty("jdbc.password")); return bds;// w ww .j av a2 s . co m }
From source file:edu.neu.webtoolsfinal.config.RepositoryConfiguration.java
@Bean(name = "dataSource") public DataSource getDataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl("jdbc:mysql://localhost:3306/deliverydb"); dataSource.setUsername("root"); dataSource.setPassword(""); return dataSource; }
From source file:com.alehuo.wepas2016projekti.configuration.ProductionConfiguration.java
/** * Heroku -palvelussa kytetn PostgreSQL -tietokantaa tiedon * tallentamiseen. Tm metodi hakee herokusta tietokantayhteyden * mahdollistavat ympristmuuttujat.// w w w .j a v a 2 s. co m * * @return @throws URISyntaxException */ @Bean public BasicDataSource dataSource() throws URISyntaxException { URI dbUri = new URI(System.getenv("DATABASE_URL")); String username = dbUri.getUserInfo().split(":")[0]; String password = dbUri.getUserInfo().split(":")[1]; String dbUrl = "jdbc:postgresql://" + dbUri.getHost() + ':' + dbUri.getPort() + dbUri.getPath(); BasicDataSource basicDataSource = new BasicDataSource(); basicDataSource.setUrl(dbUrl); basicDataSource.setUsername(username); basicDataSource.setPassword(password); //Autocommit pois plt basicDataSource.setDefaultAutoCommit(false); return basicDataSource; }
From source file:com.samovich.service.blueprint.App.java
/** * Data source configuration with dbcp//from w ww . ja v a2 s .co m * @return dataSource */ @Bean public DataSource dataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl("jdbc:mysql://HOST:PORT/DATABASE_NAME"); dataSource.setUsername("DB_USER"); dataSource.setPassword("RB_PW"); dataSource.setValidationQuery("select 1"); dataSource.setMaxTotal(50); dataSource.setTestOnBorrow(true); dataSource.setMaxWaitMillis(10000); dataSource.setRemoveAbandonedOnBorrow(true); dataSource.setDefaultAutoCommit(false); dataSource.setNumTestsPerEvictionRun(3); dataSource.setTimeBetweenEvictionRunsMillis(1800000); dataSource.setMinEvictableIdleTimeMillis(1800000); return dataSource; }
From source file:io.github.bibekshakya35.ehealth.configuration.EhealthCofiguration.java
@Bean(name = "dataSource") public javax.sql.DataSource getDataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("org.postgresql.Driver"); dataSource.setUrl("jdbc:postgresql://localhost:5432/ehealth"); dataSource.setUsername("test"); dataSource.setPassword("test123"); return dataSource; }
From source file:hu.fnf.devel.wishbox.persistence.ConfigData.java
@Bean(destroyMethod = "close") public DataSource dataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl("jdbc:mysql://sql01x/wishbox"); dataSource.setUsername(System.getProperty("SQLUser")); dataSource.setPassword(System.getProperty("SQLPass")); return dataSource; }
From source file:co.id.ipb.ilkom.training.db.SpringDataJpaConfiguration.java
@Bean DataSource dataSource() {// ww w . j a va2 s . c o m BasicDataSource dataSource = new BasicDataSource(); dataSource.setUrl("jdbc:mysql://localhost:3306/trainingjava"); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUsername("root"); dataSource.setPassword("root"); dataSource.setInitialSize(20); dataSource.setMaxIdle(20); dataSource.setMaxTotal(100); return dataSource; }