datasource.setPartitionCount(env.getProperty(DB_PARTITION_COUNT, Integer.class, DB_DEFAULT_PARTITION_COUNT)); datasource.setAcquireIncrement(env.getProperty(DB_ACQUIRE_INCREMENT, Integer.class, DB_DEFAULT_ACQUIRE_INCREMENT)); datasource.setStatementsCacheSize(env.getProperty(
dataSource.setMinConnectionsPerPartition(2); dataSource.setPartitionCount(3); dataSource.setAcquireIncrement(2); dataSource.setStatementsCacheSize(100);
dataSource.setMinConnectionsPerPartition(2); 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.setMaxConnectionsPerPartition(MaxConnPerPartition); 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; }
datasource.setMaxConnectionsPerPartition(dbConf.getIntegerWithDefault("maxConnectionsPerPartition", 30)); datasource.setMinConnectionsPerPartition(dbConf.getIntegerWithDefault("minConnectionsPerPartition", 5)); datasource.setAcquireIncrement(dbConf.getIntegerWithDefault("acquireIncrement", 1)); datasource.setAcquireRetryAttempts(dbConf.getIntegerWithDefault("acquireRetryAttempts", 10)); datasource.setAcquireRetryDelayInMs(dbConf.getIntegerWithDefault("acquireRetryDelay", 1000));