List of usage examples for org.apache.commons.dbcp BasicDataSource setPassword
public synchronized void setPassword(String password)
Sets the #password .
Note: this method currently has no effect once the pool has been initialized.
From source file:cz.muni.fi.pv168.MainForm.java
private DataSource prepareDataSource() { /*/*from w w w .jav a2 s.c om*/ * BasicDataSource ds = new BasicDataSource(); Properties properties = * new Properties(); FileInputStream in = null; try { in = new * FileInputStream("database.properties"); } catch * (FileNotFoundException ex) { * Logger.getLogger(MainForm.class.getName()).log(Level.SEVERE, "File * Not Found", ex); } try { properties.load(in); } catch (IOException * ex) { Logger.getLogger(MainForm.class.getName()).log(Level.SEVERE, * "Can Not Read Properties File", ex); } String drivers = * properties.getProperty("jdbc.drivers"); if (null == drivers) { * System.setProperty("jdbs.drivers", drivers); } String url = * properties.getProperty("jdbc.url"); String username = * properties.getProperty("jdbc.username"); String password = * properties.getProperty("jdbc.password"); ds.setUrl(url); * ds.setUsername(username); ds.setPassword(password); return ds; */ ResourceBundle databaseProperties = ResourceBundle.getBundle("cz.muni.fi.pv168.database"); String url = databaseProperties.getString("jdbc.url"); String username = databaseProperties.getString("jdbc.username"); String password = databaseProperties.getString("jdbc.password"); BasicDataSource ds = new BasicDataSource(); ds.setUrl(url); ds.setUsername(username); ds.setPassword(password); try { DBUtils.tryCreateTables(ds); } catch (SQLException ex) { JOptionPane.showMessageDialog(jMenu1, localization.getString("db_connection_failure"), localization.getString("error"), JOptionPane.ERROR_MESSAGE); } carManager.setDataSource(ds); customerManager.setDataSource(ds); rentManager.setDataSource(ds); return ds; }
From source file:com.alibaba.otter.manager.biz.common.DataSourceCreator.java
private DataSource createDataSource(String url, String userName, String password, String driverClassName, DataMediaType dataMediaType, String encoding) { BasicDataSource dbcpDs = new BasicDataSource(); dbcpDs.setInitialSize(initialSize);// ? dbcpDs.setMaxActive(maxActive);// ????? dbcpDs.setMaxIdle(maxIdle);// ?? dbcpDs.setMinIdle(minIdle);// ?0? dbcpDs.setMaxWait(maxWait);// ??-1? dbcpDs.setRemoveAbandoned(true);// ??removeAbandonedTimeout dbcpDs.setLogAbandoned(true);// ?? dbcpDs.setRemoveAbandonedTimeout(removeAbandonedTimeout); // ? dbcpDs.setNumTestsPerEvictionRun(numTestsPerEvictionRun);// ?? dbcpDs.setTestOnBorrow(false);// ?? dbcpDs.setTestOnReturn(false);// ?? dbcpDs.setTestWhileIdle(true);// ???? dbcpDs.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis); // ???????? dbcpDs.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis); // ??????? // ??//from w ww .j a va 2s .c o m dbcpDs.setDriverClassName(driverClassName); dbcpDs.setUrl(url); dbcpDs.setUsername(userName); dbcpDs.setPassword(password); if (dataMediaType.isOracle()) { dbcpDs.addConnectionProperty("restrictGetTables", "true"); // dbcpDs.setValidationQuery("select 1 from dual"); } else if (dataMediaType.isMysql()) { // open the batch mode for mysql since 5.1.8 dbcpDs.addConnectionProperty("useServerPrepStmts", "false"); dbcpDs.addConnectionProperty("rewriteBatchedStatements", "true"); dbcpDs.addConnectionProperty("zeroDateTimeBehavior", "convertToNull");// 0000-00-00null dbcpDs.addConnectionProperty("yearIsDateType", "false");// ??year?date? dbcpDs.addConnectionProperty("noDatetimeStringSync", "true");// ,??? if (StringUtils.isNotEmpty(encoding)) { if (StringUtils.equalsIgnoreCase(encoding, "utf8mb4")) { dbcpDs.addConnectionProperty("characterEncoding", "utf8"); dbcpDs.setConnectionInitSqls(Arrays.asList("set names utf8mb4")); } else { dbcpDs.addConnectionProperty("characterEncoding", encoding); } } // dbcpDs.setValidationQuery("select 1"); } else { logger.error("ERROR ## Unknow database type"); } return dbcpDs; }
From source file:com.alibaba.otter.node.etl.common.datasource.impl.DBDataSourceService.java
private DataSource createDataSource(String url, String userName, String password, String driverClassName, DataMediaType dataMediaType, String encoding) { BasicDataSource dbcpDs = new BasicDataSource(); dbcpDs.setInitialSize(initialSize);// ? dbcpDs.setMaxActive(maxActive);// ????? dbcpDs.setMaxIdle(maxIdle);// ?? dbcpDs.setMinIdle(minIdle);// ?0? dbcpDs.setMaxWait(maxWait);// ??-1? dbcpDs.setRemoveAbandoned(true);// ??removeAbandonedTimeout dbcpDs.setLogAbandoned(true);// ?? dbcpDs.setRemoveAbandonedTimeout(removeAbandonedTimeout); // ? dbcpDs.setNumTestsPerEvictionRun(numTestsPerEvictionRun);// ?? dbcpDs.setTestOnBorrow(false);// ?? dbcpDs.setTestOnReturn(false);// ?? dbcpDs.setTestWhileIdle(true);// ???? dbcpDs.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis); // ???????? dbcpDs.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis); // ??????? // ??// www . j a v a 2 s.co m dbcpDs.setDriverClassName(driverClassName); dbcpDs.setUrl(url); dbcpDs.setUsername(userName); dbcpDs.setPassword(password); if (dataMediaType.isOracle()) { dbcpDs.addConnectionProperty("restrictGetTables", "true"); dbcpDs.setValidationQuery("select 1 from dual"); } else if (dataMediaType.isMysql()) { // open the batch mode for mysql since 5.1.8 dbcpDs.addConnectionProperty("useServerPrepStmts", "false"); dbcpDs.addConnectionProperty("rewriteBatchedStatements", "true"); dbcpDs.addConnectionProperty("zeroDateTimeBehavior", "convertToNull");// 0000-00-00null dbcpDs.addConnectionProperty("yearIsDateType", "false");// ??year?date? dbcpDs.addConnectionProperty("noDatetimeStringSync", "true");// ,??? if (StringUtils.isNotEmpty(encoding)) { if (StringUtils.equalsIgnoreCase(encoding, "utf8mb4")) { dbcpDs.addConnectionProperty("characterEncoding", "utf8"); dbcpDs.setConnectionInitSqls(Arrays.asList("set names utf8mb4")); } else { dbcpDs.addConnectionProperty("characterEncoding", encoding); } } dbcpDs.setValidationQuery("select 1"); } else { logger.error("ERROR ## Unknow database type"); } return dbcpDs; }
From source file:com.alibaba.otter.common.push.datasource.media.MediaPushDataSource.java
protected DataSource doCreateDataSource(String url) { BasicDataSource dbcpDs = new BasicDataSource(); dbcpDs.setInitialSize(initialSize);// ? dbcpDs.setMaxActive(maxActive);// ????? dbcpDs.setMaxIdle(maxIdle);// ?? dbcpDs.setMinIdle(minIdle);// ?0? dbcpDs.setMaxWait(maxWait);// ??-1? dbcpDs.setRemoveAbandoned(true);// ??removeAbandonedTimeout dbcpDs.setLogAbandoned(true);// ?? dbcpDs.setRemoveAbandonedTimeout(removeAbandonedTimeout); // ? dbcpDs.setNumTestsPerEvictionRun(numTestsPerEvictionRun);// ?? dbcpDs.setTestOnBorrow(false);// ?? dbcpDs.setTestOnReturn(false);// ?? dbcpDs.setTestWhileIdle(true);// ???? dbcpDs.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis); // ???????? dbcpDs.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis); // ??????? // ??//from ww w .j av a2s.c o m dbcpDs.setDriverClassName(driverClassName); dbcpDs.setUrl(url); dbcpDs.setUsername(userName); dbcpDs.setPassword(password); if (dataMediaType.isOracle()) { dbcpDs.addConnectionProperty("restrictGetTables", "true"); dbcpDs.setValidationQuery("select 1 from dual"); } else if (dataMediaType.isMysql()) { // open the batch mode for mysql since 5.1.8 dbcpDs.addConnectionProperty("useServerPrepStmts", "false"); dbcpDs.addConnectionProperty("rewriteBatchedStatements", "true"); dbcpDs.addConnectionProperty("zeroDateTimeBehavior", "convertToNull");// 0000-00-00null dbcpDs.addConnectionProperty("yearIsDateType", "false");// ??year?date? if (StringUtils.isNotEmpty(encoding)) { dbcpDs.addConnectionProperty("characterEncoding", encoding); } dbcpDs.setValidationQuery("select 1"); } else { logger.error("ERROR ## Unknow database type"); } return dbcpDs; }
From source file:nl.surfnet.coin.db.AbstractInMemoryDatabaseTest.java
/** * We use an in-memory database - no need for Spring in this one - and * populate it with the sql statements in test-data-eb.sql * /*w w w . j av a 2 s. co m*/ * @throws Exception * unexpected */ @Before public void before() throws Exception { BasicDataSource dataSource = new BasicDataSource(); dataSource.setPassword(""); dataSource.setUsername("sa"); String url = getDataSourceUrl(); dataSource.setUrl(url); dataSource.setDriverClassName("org.hsqldb.jdbcDriver"); jdbcTemplate = new JdbcTemplate(dataSource); ClassPathResource resource = new ClassPathResource(getMockDataContentFilename()); logger.debug("Loading database content from " + resource); if (resource.exists()) { final String sql = IOUtils.toString(resource.getInputStream()); final String[] split = sql.split(";"); for (String s : split) { if (!StringUtils.hasText(s)) { continue; } jdbcTemplate.execute(s + ';'); } } }
From source file:nl.surfnet.coin.db.MigrationsTest.java
private BasicDataSource hsqldbDataSource() { BasicDataSource ds = new BasicDataSource(); ds.setDriverClassName("org.hsqldb.jdbcDriver"); ds.setUrl("jdbc:hsqldb:mem:api"); ds.setUsername("sa"); ds.setPassword(""); return ds;//from w ww . j a v a 2 s . c om }
From source file:nl.surfnet.coin.db.MigrationsTest.java
private BasicDataSource mysqlDataSource() { BasicDataSource ds = new BasicDataSource(); ds.setDriverClassName("com.mysql.jdbc.Driver"); ds.setUrl("jdbc:mysql://localhost:3306/apitest"); ds.setUsername("root"); ds.setPassword(""); return ds;/*from w w w.j a va 2s . c om*/ }
From source file:nl.trivento.albero.repositories.DatabaseRepository.java
private DataSource createBasicDataSource(Map<String, String> parameters) throws ConfigurationException { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName(parameters.get(DRIVER)); dataSource.setUrl(parameters.get(URL)); dataSource.setUsername(parameters.get(USER)); dataSource.setPassword(parameters.get(PASSWORD)); return dataSource; }
From source file:org.activiti.spring.test.jpa.JPASpringTest.java
@Bean public DataSource dataSource() { BasicDataSource basicDataSource = new BasicDataSource(); basicDataSource.setUsername("sa"); basicDataSource.setUrl("jdbc:h2:mem:activiti"); basicDataSource.setDefaultAutoCommit(false); basicDataSource.setDriverClassName(org.h2.Driver.class.getName()); basicDataSource.setPassword(""); return basicDataSource; }
From source file:org.ambraproject.doi.BaseResolverTest.java
@BeforeClass public void createDB() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("org.hsqldb.jdbcDriver"); dataSource.setUrl("jdbc:hsqldb:mem:testdb"); dataSource.setUsername("sa"); dataSource.setPassword(""); this.dataSource = dataSource; jdbcTemplate = new JdbcTemplate(dataSource); jdbcTemplate.execute("drop table if exists annotation;" + "drop table if exists article;" + "create table article (" + " articleID bigint not null," + " doi varchar(255) not null," + " primary key (articleID)" + ");" + "create table annotation (" + " annotationID bigint not null," + " annotationURI varchar(255) not null," + " articleID bigint null," + " type varchar(16) default null," + " primary key (annotationID)" + ");" + "alter table annotation add foreign key (articleID) references article (articleID);"); }