dataSource.setUsername(conf.getProperty("db.user")); dataSource.setPassword(conf.getProperty("db.password")); dataSource.setIdleConnectionTestPeriodInMinutes( Long.parseLong( conf.getProperty("db.bonecp.idleConnectionTestPeriod")));
dataSource.setUsername(conf.getProperty("db.user")); dataSource.setPassword(conf.getProperty("db.password")); dataSource.setIdleConnectionTestPeriodInMinutes( Long.parseLong( conf.getProperty("db.bonecp.idleConnectionTestPeriod")));
dataSource.setUsername(environment.getProperty("database.username")); dataSource.setPassword(environment.getProperty("database.password")); dataSource.setIdleConnectionTestPeriodInMinutes(30); dataSource.setMaxConnectionsPerPartition(5); dataSource.setMinConnectionsPerPartition(2);
dataSource.setUsername(environment.getProperty("database.username")); dataSource.setPassword(environment.getProperty("database.password")); dataSource.setIdleConnectionTestPeriodInMinutes(30); dataSource.setMaxConnectionsPerPartition(5); dataSource.setMinConnectionsPerPartition(2);
@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; } }
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; }