datasource.setAcquireIncrement(env.getProperty(DB_ACQUIRE_INCREMENT, Integer.class, DB_DEFAULT_ACQUIRE_INCREMENT)); datasource.setStatementsCacheSize(env.getProperty( DB_STATEMENTS_CACHE_SIZE, Integer.class, DB_DEFAULT_STATEMENTS_CACHE_SIZE));
dataSource.setPartitionCount(3); dataSource.setAcquireIncrement(2); dataSource.setStatementsCacheSize(100);
dataSource.setPartitionCount(3); dataSource.setAcquireIncrement(2); dataSource.setStatementsCacheSize(100);
@Bean(destroyMethod = "close") public DataSource mainDataSource() { BoneCPDataSource dataSource = new BoneCPDataSource(); dataSource.setDriverClass(jdbcDriverClass); dataSource.setJdbcUrl(jdbcUrl); dataSource.setUsername(jdbcUsername); dataSource.setPassword(jdbcPassword); dataSource.setIdleConnectionTestPeriodInMinutes(2); dataSource.setIdleMaxAge(2, TimeUnit.HOURS); dataSource.setMaxConnectionsPerPartition(60); dataSource.setMinConnectionsPerPartition(20); dataSource.setPartitionCount(3); dataSource.setAcquireIncrement(10); dataSource.setStatementsCacheSize(50); return dataSource; } }
dataSource.setPartitionCount(PartitionCount); dataSource.setAcquireIncrement(AcquireIncrement); dataSource.setStatementsCacheSize(StatementsCacheSize); dataSource.setMaxConnectionAgeInSeconds(timeoutPeriod);
private BoneCPDataSource createNewDataSource() { BoneCPDataSource target = new BoneCPDataSource(); target.setDriverClass(config.getDriverClassName()); target.setJdbcUrl(config.getJdbcUrl()); target.setUsername(config.getUserName()); target.setPassword(config.getPassword()); target.setIdleConnectionTestPeriodInMinutes(config.getIdleConnectionTestPeriodInMinutes()); target.setIdleMaxAgeInMinutes(config.getIdleMaxAgeInMinutes()); target.setMaxConnectionsPerPartition(config.getMaxConnectionsPerPartition()); target.setMinConnectionsPerPartition(config.getMinConnectionsPerPartition()); target.setPartitionCount(config.getPartitionCount()); target.setAcquireIncrement(config.getAcquireIncrement()); target.setStatementsCacheSize(config.getStatementsCacheSize()); target.setDisableJMX(true); return target; }
if (size >= 0) ds.setStatementsCacheSize(size);