List of usage examples for org.apache.commons.dbcp SakaiBasicDataSource setDefaultReadOnly
public synchronized void setDefaultReadOnly(boolean defaultReadOnly)
Sets defaultReadonly property.
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);/* www. ja v a2s.co 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 . jav 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);/*from ww w . j a v a 2s . 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 . jav a 2 s.co 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; }