Example usage for org.apache.commons.dbcp2 BasicDataSource setMaxTotal

Introduction

In this page you can find the example usage for org.apache.commons.dbcp2 BasicDataSource setMaxTotal.

Prototype

public synchronized void setMaxTotal(int maxTotal) 

Source Link

Document

Sets the maximum total number of idle and borrows connections that can be active at the same time.

Usage

From source file:com.sinotopia.mybatis.plus.test.GlobalConfigurationTest.java

/**
 * ?/*  w  ww. j  a  va 2s  .c om*/
 */
@SuppressWarnings("unchecked")
public static void main(String[] args) {
    GlobalConfiguration global = GlobalConfiguration.defaults();
    global.setAutoSetDbType(true);
    // FieldStrategy.Empty
    global.setFieldStrategy(2);
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/mybatis-plus?characterEncoding=UTF-8");
    dataSource.setUsername("root");
    dataSource.setPassword("521");
    dataSource.setMaxTotal(1000);
    GlobalConfiguration.setMetaData(dataSource, global);
    // ?
    InputStream inputStream = GlobalConfigurationTest.class.getClassLoader()
            .getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder factoryBuilder = new MybatisSessionFactoryBuilder();
    factoryBuilder.setGlobalConfig(global);
    SqlSessionFactory sessionFactory = factoryBuilder.build(inputStream);
    SqlSession session = sessionFactory.openSession(false);
    TestMapper testMapper = session.getMapper(TestMapper.class);
    /*Wrapper type = Condition.instance().eq("id",1).or().in("type", new Object[]{1, 2, 3, 4, 5, 6});
    List list = testMapper.selectList(type);
    System.out.println(list.toString());*/
    Test test = new Test();
    test.setCreateTime(new Date());
    // ?
    test.setType("");
    testMapper.insert(test);

    SqlSession sqlSession = sessionFactory.openSession(false);
    NotPKMapper pkMapper = sqlSession.getMapper(NotPKMapper.class);
    NotPK notPK = new NotPK();
    notPK.setUuid(UUID.randomUUID().toString());
    int num = pkMapper.insert(notPK);
    Assert.assertTrue(num > 0);
    NotPK notPK1 = pkMapper.selectOne(notPK);
    Assert.assertNotNull(notPK1);
    pkMapper.selectPage(RowBounds.DEFAULT, Condition.create().eq("type", 12121212));
    NotPK notPK2 = null;
    try {
        notPK2 = pkMapper.selectById("1");
    } catch (Exception e) {
        System.out.println(",");
    }
    Assert.assertNull(notPK2);
    int count = pkMapper.selectCount(Condition.EMPTY);
    Assert.assertTrue(count > 0);
    int deleteCount = pkMapper.delete(null);
    Assert.assertTrue(deleteCount > 0);
    session.rollback();
    sqlSession.commit();
}

---

From source file:com.edu.ufps.maregroups.util.Pool.java

private static void inicializarDataSource() {
    BasicDataSource dsBasico = new BasicDataSource();
    dsBasico.setDriverClassName(DB_DRIVER);
    dsBasico.setUsername(DB_USUARIO);//from   w  w w .  ja  v  a 2s.c om
    dsBasico.setPassword(DB_CONTRASENA);
    dsBasico.setUrl(DB_URL);
    dsBasico.setMaxTotal(100);
    datasource = dsBasico;
}

---

From source file:gruposinvestigacion.model.util.Pool.java

private static void inicializarDataSource() {
    BasicDataSource dsBasico = new BasicDataSource();
    dsBasico.setDriverClassName(db_driver);
    dsBasico.setUsername(db_usuario);/*from  ww w.j  a va2s . c o m*/
    dsBasico.setPassword(db_contrasena);
    dsBasico.setUrl(db_url);
    dsBasico.setMaxTotal(100);
    datasource = dsBasico;
}

---

From source file:edu.emory.cci.aiw.i2b2etl.ConfigurationFactory.java

private static BasicDataSource newBasicDataSource(String url) {
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName(DRIVER_CLASS_NAME);
    bds.setUrl(url);/*from   w w w . j  av a2 s.com*/
    bds.setMinIdle(MIN_IDLE);
    bds.setMaxIdle(MAX_IDLE);
    bds.setMaxTotal(MAX_TOTAL);
    return bds;
}

---

From source file:com.github.akiraly.db4j.pool.DbcpUtils.java

public static BasicDataSource newDefaultDS() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDefaultAutoCommit(false);

    dataSource.setDefaultQueryTimeout(1);
    dataSource.setValidationQueryTimeout(1);
    dataSource.setMaxWaitMillis(5000);//from w  w  w.  j  a  va  2 s .  c  om

    dataSource.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

    dataSource.setInitialSize(4);
    dataSource.setMinIdle(4);
    dataSource.setMaxIdle(8);
    dataSource.setMaxTotal(16);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setMaxOpenPreparedStatements(128);
    return dataSource;
}

---

From source file:de.anycook.db.mysql.DBHandler.java

private static BasicDataSource setupDataSource(String server, int port, String dbName, String username,
        String password, int maxActive, int maxIdle) {
    Preconditions.checkNotNull(server);//from   ww  w.j  a v  a  2  s.c  o m
    Preconditions.checkNotNull(dbName);
    Preconditions.checkNotNull(username);

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUsername(username);

    if (password.length() > 0) {
        ds.setPassword(password);
    }

    String url = String.format("jdbc:mysql://%s:%d/%s?useConfigs=maxPerformance&useCompression=true", server,
            port, dbName);
    ds.setUrl(url);
    ds.setValidationQuery("SELECT 1;");
    ds.setTestWhileIdle(true);
    ds.setTestOnReturn(true);
    ds.setMaxTotal(maxActive);
    ds.setMaxIdle(maxIdle);
    ds.setRemoveAbandonedOnBorrow(true);
    ds.setRemoveAbandonedTimeout(60);

    if (Configuration.getInstance().isDeveloperMode()) {
        ds.setLogAbandoned(true);
    }

    sLogger.info("created new Connectionpool");
    return ds;
}

---

From source file:com.samovich.service.blueprint.App.java

/**
 * Data source configuration with dbcp//  ww w  .  j  a  va  2s. com
 * @return dataSource
 */
@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://HOST:PORT/DATABASE_NAME");
    dataSource.setUsername("DB_USER");
    dataSource.setPassword("RB_PW");
    dataSource.setValidationQuery("select 1");
    dataSource.setMaxTotal(50);
    dataSource.setTestOnBorrow(true);
    dataSource.setMaxWaitMillis(10000);
    dataSource.setRemoveAbandonedOnBorrow(true);
    dataSource.setDefaultAutoCommit(false);
    dataSource.setNumTestsPerEvictionRun(3);
    dataSource.setTimeBetweenEvictionRunsMillis(1800000);
    dataSource.setMinEvictableIdleTimeMillis(1800000);
    return dataSource;
}

---

From source file:com.peertopark.spring.data.SpringDataConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl(dataSourceConfig.getJDBCUrl());
    dataSource.setUsername(dataSourceConfig.getJDBCUser());
    dataSource.setPassword(dataSourceConfig.getJDBCPassword());
    dataSource.setDriverClassName(dataSourceConfig.getJDBCDriver());
    dataSource.setMaxTotal(dataSourceConfig.getMaxConnections());
    return dataSource;
}

---

From source file:co.id.ipb.ilkom.training.db.SpringDataJpaConfiguration.java

@Bean
DataSource dataSource() {// www.ja  v  a2s  .co  m
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl("jdbc:mysql://localhost:3306/trainingjava");
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUsername("root");
    dataSource.setPassword("root");
    dataSource.setInitialSize(20);
    dataSource.setMaxIdle(20);
    dataSource.setMaxTotal(100);
    return dataSource;
}

---

From source file:com.zaxxer.hikari.benchmark.BenchBase.java

private void setupDBCP2basic() throws SQLException {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(dbDriver);//ww w.ja  v  a  2 s .  c  om
    ds.setUsername("sa");
    ds.setPassword("");
    ds.setUrl(jdbcURL);
    ds.setMaxTotal(maxPoolSize);
    ds.setDefaultAutoCommit(false);
    ds.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

    ds.getConnection().createStatement().execute("CREATE TABLE IF NOT EXISTS test (column varchar);");
    DS = ds;
}

---

• «
• 1
• 2
• 3
• »