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

Introduction

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

Prototype

public synchronized void setMaxIdle(int maxIdle) 

Source Link

Document

Sets the maximum number of connections that can remail idle in the pool.

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 a v a2  s  . 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;
}

---

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  ava 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);/* 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 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 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;
}

---