List of usage examples for org.apache.commons.dbcp SakaiBasicDataSource 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:org.etudes.mneme.impl.CharTestXmysql.java
protected SakaiBasicDataSource setupDataSource() { // a data source (see db/pack/components.xml javax.sql.BaseDataSource) SakaiBasicDataSource ds = new SakaiBasicDataSource(); ds.setDriverClassName("com.mysql.jdbc.Driver"); ds.setUrl("jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8"); ds.setUsername("sakaiuser"); ds.setPassword("password"); ds.setInitialSize(10);/*from w ww .j av a 2 s . c o m*/ ds.setMaxActive(10); ds.setMaxIdle(10); ds.setMinIdle(10); ds.setMaxWait(300000); ds.setNumTestsPerEvictionRun(3); ds.setTestOnBorrow(true); ds.setTestOnReturn(false); ds.setTestWhileIdle(false); ds.setValidationQuery("select 1 from DUAL"); ds.setDefaultAutoCommit(false); ds.setDefaultReadOnly(false); ds.setDefaultTransactionIsolationString("TRANSACTION_READ_COMMITTED"); ds.setPoolPreparedStatements(false); ds.setMaxOpenPreparedStatements(0); ds.setMinEvictableIdleTimeMillis(1800000); ds.setTimeBetweenEvictionRunsMillis(900000); return ds; }
From source file:org.etudes.mneme.impl.CharTestXoracle.java
protected SakaiBasicDataSource setupDataSource() { // a data source (see db/pack/components.xml javax.sql.BaseDataSource) SakaiBasicDataSource ds = new SakaiBasicDataSource(); ds.setDriverClassName("oracle.jdbc.driver.OracleDriver"); ds.setUrl("jdbc:oracle:thin:@localhost:11004:sakaidev"); ds.setUsername("ggolden"); ds.setPassword("ggolden"); ds.setInitialSize(10);/*w w w .j a v a2s . c o m*/ ds.setMaxActive(10); ds.setMaxIdle(10); ds.setMinIdle(10); ds.setMaxWait(300000); ds.setNumTestsPerEvictionRun(3); ds.setTestOnBorrow(true); ds.setTestOnReturn(false); ds.setTestWhileIdle(false); ds.setValidationQuery("select 1 from DUAL"); ds.setDefaultAutoCommit(false); ds.setDefaultReadOnly(false); ds.setDefaultTransactionIsolationString("TRANSACTION_READ_COMMITTED"); ds.setPoolPreparedStatements(false); ds.setMaxOpenPreparedStatements(0); ds.setMinEvictableIdleTimeMillis(1800000); ds.setTimeBetweenEvictionRunsMillis(900000); return ds; }
From source file:org.etudes.mneme.impl.TestX.java
protected SakaiBasicDataSource setupDataSourceMysql() { // a data source (see db/pack/components.xml javax.sql.BaseDataSource) SakaiBasicDataSource ds = new SakaiBasicDataSource(); ds.setDriverClassName("com.mysql.jdbc.Driver"); ds.setUrl("jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8"); ds.setUsername("sakaiuser"); ds.setPassword("password"); ds.setInitialSize(10);//w ww.jav a 2 s .c o m ds.setMaxActive(10); ds.setMaxIdle(10); ds.setMinIdle(10); ds.setMaxWait(300000); ds.setNumTestsPerEvictionRun(3); ds.setTestOnBorrow(true); ds.setTestOnReturn(false); ds.setTestWhileIdle(false); ds.setValidationQuery("select 1 from DUAL"); ds.setDefaultAutoCommit(false); ds.setDefaultReadOnly(false); ds.setDefaultTransactionIsolationString("TRANSACTION_READ_COMMITTED"); ds.setPoolPreparedStatements(false); ds.setMaxOpenPreparedStatements(0); ds.setMinEvictableIdleTimeMillis(1800000); ds.setTimeBetweenEvictionRunsMillis(900000); return ds; }
From source file:org.etudes.mneme.impl.TestX.java
protected SakaiBasicDataSource setupDataSourceOracle() { // a data source (see db/pack/components.xml javax.sql.BaseDataSource) SakaiBasicDataSource ds = new SakaiBasicDataSource(); ds.setDriverClassName("oracle.jdbc.driver.OracleDriver"); ds.setUrl("jdbc:oracle:thin:@localhost:11004:sakaidev"); ds.setUsername("ggolden"); ds.setPassword("ggolden"); ds.setInitialSize(10);/*from w w w . j a v a 2s . c om*/ ds.setMaxActive(10); ds.setMaxIdle(10); ds.setMinIdle(10); ds.setMaxWait(300000); ds.setNumTestsPerEvictionRun(3); ds.setTestOnBorrow(true); ds.setTestOnReturn(false); ds.setTestWhileIdle(false); ds.setValidationQuery("select 1 from DUAL"); ds.setDefaultAutoCommit(false); ds.setDefaultReadOnly(false); ds.setDefaultTransactionIsolationString("TRANSACTION_READ_COMMITTED"); ds.setPoolPreparedStatements(false); ds.setMaxOpenPreparedStatements(0); ds.setMinEvictableIdleTimeMillis(1800000); ds.setTimeBetweenEvictionRunsMillis(900000); return ds; }