@Override public synchronized void setNumTestsPerEvictionRun(int numTestsPerEvictionRun) { delegate.setNumTestsPerEvictionRun(numTestsPerEvictionRun); }
dbcpDataSource.setTimeBetweenEvictionRunsMillis(getIntProperty(config, "timeBetweenEvictionRunsMillis", 30000)); // 30s dbcpDataSource.setRemoveAbandonedTimeout(getIntProperty(config, "removeAbandonedTimeout", 300)); // 30s dbcpDataSource.setNumTestsPerEvictionRun(getIntProperty(config, "numTestsPerEvictionRun", 6)); // 30s dbcpDataSource.setValidationQueryTimeout(getIntProperty(config, "validationQueryTimeout", 0)); if (StringUtils.isNotBlank(getStringProperty(config, "connectionInitSql", null))) {
@ManagedAttribute @Description("Set the minimum number of active connections that can remain idle in the pool, without extra ones" + " being created when the evictor runs, or 0 to create none.") public void setNumTestsPerEvictionRun(final int num) { ds.setNumTestsPerEvictionRun(num); }
@Primary @Bean(name = "readableDataSource") @ConfigurationProperties(prefix = "spring.datasource2") public DataSource writeDataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setRemoveAbandoned(true); dataSource.setTestWhileIdle(true); dataSource.setTimeBetweenEvictionRunsMillis(30000); dataSource.setNumTestsPerEvictionRun(30); dataSource.setMinEvictableIdleTimeMillis(1800000); return dataSource; }
@Primary @Bean(name = "writeableDataSource") @ConfigurationProperties(prefix = "spring.datasource") public DataSource writeDataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setRemoveAbandoned(true); dataSource.setTestWhileIdle(true); dataSource.setTimeBetweenEvictionRunsMillis(30000); dataSource.setNumTestsPerEvictionRun(30); dataSource.setMinEvictableIdleTimeMillis(1800000); return dataSource; }
dataSource.setNumTestsPerEvictionRun(evictorTestsPerRun);
dataSource.setNumTestsPerEvictionRun(Integer.parseInt(value));
dataSource.setNumTestsPerEvictionRun(Integer.parseInt(value));
dataSource.setNumTestsPerEvictionRun(Integer.parseInt(value));
@Primary @Bean(destroyMethod = "close", name = "dataSource") public DataSource dataSource(DataSourceProperties properties) { log.info("*************************dataSource***********************"); BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName(properties.driverClassName); dataSource.setUrl(properties.url); dataSource.setUsername(properties.username); dataSource.setPassword(properties.password); dataSource.setMaxIdle(properties.maxIdle); dataSource.setMaxActive(properties.maxActive); dataSource.setMaxWait(properties.maxWait); dataSource.setInitialSize(properties.initialSize); dataSource.setValidationQuery(properties.validationQuery); dataSource.setRemoveAbandoned(true); dataSource.setTestWhileIdle(true); dataSource.setTimeBetweenEvictionRunsMillis(30000); dataSource.setNumTestsPerEvictionRun(30); dataSource.setMinEvictableIdleTimeMillis(1800000); return dataSource; }
@Bean(destroyMethod = "close", name = "readOnlyDataSource") public DataSource dataSource(@Qualifier("readOnlyDataSourceProperties") DataSourceProperties readOnlyDataSourceProperties) { log.info("*************************dataSource***********************"); BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName(readOnlyDataSourceProperties.driverClassName); dataSource.setUrl(readOnlyDataSourceProperties.url); dataSource.setUsername(readOnlyDataSourceProperties.username); dataSource.setPassword(readOnlyDataSourceProperties.password); dataSource.setMaxIdle(readOnlyDataSourceProperties.maxIdle); dataSource.setMaxActive(readOnlyDataSourceProperties.maxActive); dataSource.setMaxWait(readOnlyDataSourceProperties.maxWait); dataSource.setInitialSize(readOnlyDataSourceProperties.initialSize); dataSource.setValidationQuery(readOnlyDataSourceProperties.validationQuery); dataSource.setRemoveAbandoned(true); dataSource.setTestWhileIdle(true); dataSource.setTimeBetweenEvictionRunsMillis(30000); dataSource.setNumTestsPerEvictionRun(30); dataSource.setMinEvictableIdleTimeMillis(1800000); return dataSource; }
@Bean(destroyMethod = "close", name = "dataSource") public DataSource dataSource(DataSourceProperties properties) { log.info("*************************dataSource***********************"); BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName(properties.driverClassName); dataSource.setUrl(properties.url); dataSource.setUsername(properties.username); dataSource.setPassword(properties.password); dataSource.setMaxIdle(properties.maxIdle); dataSource.setMaxActive(properties.maxActive); dataSource.setMaxWait(properties.maxWait); dataSource.setInitialSize(properties.initialSize); dataSource.setValidationQuery(properties.validationQuery); dataSource.setRemoveAbandoned(true); dataSource.setTestWhileIdle(true); dataSource.setTimeBetweenEvictionRunsMillis(30000); dataSource.setNumTestsPerEvictionRun(30); dataSource.setMinEvictableIdleTimeMillis(1800000); return dataSource; }
@Bean(destroyMethod = "close", name = "dataSource") public DataSource dataSource(DataSourceProperties properties) { log.info("*************************dataSource***********************"); BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName(properties.driverClassName); dataSource.setUrl(properties.url); dataSource.setUsername(properties.username); dataSource.setPassword(properties.password); dataSource.setMaxIdle(properties.maxIdle); dataSource.setMaxActive(properties.maxActive); dataSource.setMaxWait(properties.maxWait); dataSource.setInitialSize(properties.initialSize); dataSource.setValidationQuery(properties.validationQuery); dataSource.setRemoveAbandoned(true); dataSource.setTestWhileIdle(true); dataSource.setTimeBetweenEvictionRunsMillis(30000); dataSource.setNumTestsPerEvictionRun(30); dataSource.setMinEvictableIdleTimeMillis(1800000); return dataSource; }
dataSource.setMinEvictableIdleTimeMillis(5 * 60 * 1000); dataSource.setTimeBetweenEvictionRunsMillis(3 * 60 * 1000); dataSource.setNumTestsPerEvictionRun(poolSize);
dbcpDs.setLogAbandoned(true);// 当清除无效链接时是否在日志中记录清除信息的标志 dbcpDs.setNumTestsPerEvictionRun(numTestsPerEvictionRun);// 确保连接池中没有已破损的连接 dbcpDs.setTestOnBorrow(false);// 指定连接被调用时是否经过校验 dbcpDs.setTestOnReturn(false);// 指定连接返回到池中时是否经过校验
dbcpDs.setLogAbandoned(true);// 当清除无效链接时是否在日志中记录清除信息的标志 dbcpDs.setNumTestsPerEvictionRun(numTestsPerEvictionRun);// 确保连接池中没有已破损的连接 dbcpDs.setTestOnBorrow(false);// 指定连接被调用时是否经过校验 dbcpDs.setTestOnReturn(false);// 指定连接返回到池中时是否经过校验
basicDataSource.setTimeBetweenEvictionRunsMillis( dataSourceInformation.getTimeBetweenEvictionRunsMillis()); basicDataSource.setNumTestsPerEvictionRun( dataSourceInformation.getNumTestsPerEvictionRun()); basicDataSource.setMaxOpenPreparedStatements(
basicDataSource.setTimeBetweenEvictionRunsMillis( dataSourceInformation.getTimeBetweenEvictionRunsMillis()); basicDataSource.setNumTestsPerEvictionRun( dataSourceInformation.getNumTestsPerEvictionRun()); basicDataSource.setMaxOpenPreparedStatements(