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

Introduction

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

Prototype

public synchronized void setPoolPreparedStatements(boolean poolingStatements)

Source Link

Document

Sets whether to pool statements or not.

Note: this method currently has no effect once the pool has been initialized.

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