Example usage for org.apache.commons.dbcp SakaiBasicDataSource setNumTestsPerEvictionRun

Introduction

In this page you can find the example usage for org.apache.commons.dbcp SakaiBasicDataSource setNumTestsPerEvictionRun.

Prototype

public synchronized void setNumTestsPerEvictionRun(int numTestsPerEvictionRun) 

Source Link

Document

Sets the value of the #numTestsPerEvictionRun property.

Usage

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  2s .com*/
    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);/*  ww w .j a va 2s.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.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 w  ww . 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 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 .  ja  v  a2  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;
}

---