當前位置: 首頁>>代碼示例>>Java>>正文


Java DruidDataSource.setTestWhileIdle方法代碼示例

本文整理匯總了Java中com.alibaba.druid.pool.DruidDataSource.setTestWhileIdle方法的典型用法代碼示例。如果您正苦於以下問題:Java DruidDataSource.setTestWhileIdle方法的具體用法?Java DruidDataSource.setTestWhileIdle怎麽用?Java DruidDataSource.setTestWhileIdle使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在com.alibaba.druid.pool.DruidDataSource的用法示例。


在下文中一共展示了DruidDataSource.setTestWhileIdle方法的15個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的Java代碼示例。

示例1: init

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
/**
 * 初始化操作
 *
 * @param modelName 模塊名稱
 * @param txConfig  配置信息
 */
@Override
public void init(String modelName, TxConfig txConfig) {
    dataSource = new DruidDataSource();
    final TxDbConfig txDbConfig = txConfig.getTxDbConfig();
    dataSource.setUrl(txDbConfig.getUrl());
    dataSource.setDriverClassName(txDbConfig.getDriverClassName());
    dataSource.setUsername(txDbConfig.getUsername());
    dataSource.setPassword(txDbConfig.getPassword());


    dataSource.setInitialSize(txDbConfig.getInitialSize());
    dataSource.setMaxActive(txDbConfig.getMaxActive());
    dataSource.setMinIdle(txDbConfig.getMinIdle());
    dataSource.setMaxWait(txDbConfig.getMaxWait());
    dataSource.setValidationQuery(txDbConfig.getValidationQuery());
    dataSource.setTestOnBorrow(txDbConfig.getTestOnBorrow());
    dataSource.setTestOnReturn(txDbConfig.getTestOnReturn());
    dataSource.setTestWhileIdle(txDbConfig.getTestWhileIdle());
    dataSource.setPoolPreparedStatements(txDbConfig.getPoolPreparedStatements());
    dataSource.setMaxPoolPreparedStatementPerConnectionSize(txDbConfig.getMaxPoolPreparedStatementPerConnectionSize());


    this.tableName = RepositoryPathUtils.buildDbTableName(modelName);
    executeUpdate(SqlHelper.buildCreateTableSql(tableName, txDbConfig.getDriverClassName()));
}
 
開發者ID:yu199195,項目名稱:happylifeplat-transaction,代碼行數:32,代碼來源:JdbcTransactionRecoverRepository.java

示例2: logDataSource

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean(initMethod = "init", destroyMethod = "close")
public DruidDataSource logDataSource() throws SQLException, DESException {
    DruidDataSource druidDataSource = new DruidDataSource();
    druidDataSource.setDriverClassName(dbConfigProperties.getDriveClass());
    druidDataSource.setUrl(dbConfigProperties.getLogUrl());
    druidDataSource.setUsername(dbConfigProperties.getLogUsername());
    druidDataSource.setPassword(dbConfigProperties.getLogPassword());
    druidDataSource.setInitialSize(dbConfigProperties.getInitialSize());
    druidDataSource.setMinIdle(dbConfigProperties.getMinIdle());
    druidDataSource.setMaxActive(dbConfigProperties.getMaxActive());
    druidDataSource.setMaxWait(dbConfigProperties.getMaxWait());
    druidDataSource.setTimeBetweenEvictionRunsMillis(dbConfigProperties.getTimeBetweenEvictionRunsMillis());
    druidDataSource.setMinEvictableIdleTimeMillis(dbConfigProperties.getMinEvictableIdleTimeMillis());
    druidDataSource.setValidationQuery(dbConfigProperties.getValidationQuery());
    druidDataSource.setTestWhileIdle(dbConfigProperties.getTestWhileIdle());
    druidDataSource.setTestOnBorrow(dbConfigProperties.getTestOnBorrow());
    druidDataSource.setTestOnReturn(dbConfigProperties.getTestOnReturn());
    druidDataSource.setPoolPreparedStatements(dbConfigProperties.getPoolPreparedStatements());
    druidDataSource.setMaxPoolPreparedStatementPerConnectionSize(dbConfigProperties.getMaxPoolPreparedStatementPerConnectionSize());
    druidDataSource.setFilters(dbConfigProperties.getFilters());
    return druidDataSource;
}
 
開發者ID:DomKing,項目名稱:busi-support,代碼行數:23,代碼來源:LogDatabaseConfig.java

示例3: studentDataSource

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean(name = "studentDataSource")
public DataSource studentDataSource() {
	DruidDataSource dataSource = new DruidDataSource();
	dataSource.setUrl(studentUrl);
	dataSource.setUsername(studentUser);
	dataSource.setPassword(studentPassword);
	dataSource.setDriverClassName(studentDriverClass);
	//configuration
	dataSource.setInitialSize(initialSize);
	dataSource.setMinIdle(minIdle);
	dataSource.setMaxActive(maxActive);
	dataSource.setMaxWait(maxWait);
	dataSource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
	dataSource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
	dataSource.setValidationQuery(validationQuery);
	dataSource.setTestWhileIdle(testWhileIdle);
	dataSource.setTestOnBorrow(testOnBorrow);
	dataSource.setTestOnReturn(testOnReturn);
	dataSource.setPoolPreparedStatements(poolPreparedStatements);
	dataSource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
	return dataSource;
}
 
開發者ID:ychaoyang,項目名稱:autotest,代碼行數:23,代碼來源:StudentDataSourceConfig.java

示例4: mafMasterDataSource

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean(name = ConfigConstant.NAME_DS_MASTER)
@Primary
@ConfigurationProperties(prefix = ConfigConstant.PREFIX_DS_MASTER)
public DataSource mafMasterDataSource() {
    logger.info("----- MAFIA master data source INIT -----");
    DruidDataSource ds = new DruidDataSource();
    try {
        ds.setFilters(env.getProperty("ds.filters"));
    } catch (SQLException e) {
        logger.warn("Data source set filters ERROR:", e);
    }
    ds.setMaxActive(NumberUtils.toInt(env.getProperty("ds.maxActive"), 90));
    ds.setInitialSize(NumberUtils.toInt(env.getProperty("ds.initialSize"), 10));
    ds.setMaxWait(NumberUtils.toInt(env.getProperty("ds.maxWait"), 60000));
    ds.setMinIdle(NumberUtils.toInt(env.getProperty("ds.minIdle"), 1));
    ds.setTimeBetweenEvictionRunsMillis(NumberUtils.toInt(env.getProperty("ds.timeBetweenEvictionRunsMillis"), 60000));
    ds.setMinEvictableIdleTimeMillis(NumberUtils.toInt(env.getProperty("ds.minEvictableIdleTimeMillis"), 300000));
    ds.setValidationQuery(env.getProperty("ds.validationQuery"));
    ds.setTestWhileIdle(BooleanUtils.toBoolean(env.getProperty("ds.testWhileIdle")));
    ds.setTestOnBorrow(BooleanUtils.toBoolean(env.getProperty("ds.testOnBorrow")));
    ds.setTestOnReturn(BooleanUtils.toBoolean(env.getProperty("ds.testOnReturn")));
    ds.setPoolPreparedStatements(BooleanUtils.toBoolean(env.getProperty("ds.poolPreparedStatements")));
    ds.setMaxOpenPreparedStatements(NumberUtils.toInt(env.getProperty("ds.maxOpenPreparedStatements"), 20));
    return ds;
}
 
開發者ID:slking1987,項目名稱:mafia,代碼行數:26,代碼來源:DsMasterConfig.java

示例5: init

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
/**
 * 初始化操作
 *
 * @param modelName 模塊名稱
 * @param txConfig  配置信息
 */
@Override
public void init(String modelName, TccConfig txConfig) {
    dataSource = new DruidDataSource();
    final TccDbConfig tccDbConfig = txConfig.getTccDbConfig();
    dataSource.setUrl(tccDbConfig.getUrl());
    dataSource.setDriverClassName(tccDbConfig.getDriverClassName());
    dataSource.setUsername(tccDbConfig.getUsername());
    dataSource.setPassword(tccDbConfig.getPassword());
    dataSource.setInitialSize(tccDbConfig.getInitialSize());
    dataSource.setMaxActive(tccDbConfig.getMaxActive());
    dataSource.setMinIdle(tccDbConfig.getMinIdle());
    dataSource.setMaxWait(tccDbConfig.getMaxWait());
    dataSource.setValidationQuery(tccDbConfig.getValidationQuery());
    dataSource.setTestOnBorrow(tccDbConfig.getTestOnBorrow());
    dataSource.setTestOnReturn(tccDbConfig.getTestOnReturn());
    dataSource.setTestWhileIdle(tccDbConfig.getTestWhileIdle());
    dataSource.setPoolPreparedStatements(tccDbConfig.getPoolPreparedStatements());
    dataSource.setMaxPoolPreparedStatementPerConnectionSize(tccDbConfig.getMaxPoolPreparedStatementPerConnectionSize());
    this.tableName = RepositoryPathUtils.buildDbTableName(modelName);
    executeUpdate(SqlHelper.buildCreateTableSql(tccDbConfig.getDriverClassName(), tableName));
}
 
開發者ID:yu199195,項目名稱:happylifeplat-tcc,代碼行數:28,代碼來源:JdbcCoordinatorRepository.java

示例6: mafSlaveDataSource

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean(name = ConfigConstant.NAME_DS_SLAVE)
@ConfigurationProperties(prefix = ConfigConstant.PREFIX_DS_SLAVE)
public DataSource mafSlaveDataSource() {
    logger.info("----- MAFIA slave data source INIT -----");
    DruidDataSource ds = new DruidDataSource();
    try {
        ds.setFilters(env.getProperty("ds.filters"));
    } catch (SQLException e) {
        logger.warn("Data source set filters ERROR:", e);
    }
    ds.setMaxActive(NumberUtils.toInt(env.getProperty("ds.maxActive"), 90));
    ds.setInitialSize(NumberUtils.toInt(env.getProperty("ds.initialSize"), 10));
    ds.setMaxWait(NumberUtils.toInt(env.getProperty("ds.maxWait"), 60000));
    ds.setMinIdle(NumberUtils.toInt(env.getProperty("ds.minIdle"), 1));
    ds.setTimeBetweenEvictionRunsMillis(NumberUtils.toInt(env.getProperty("ds.timeBetweenEvictionRunsMillis"), 60000));
    ds.setMinEvictableIdleTimeMillis(NumberUtils.toInt(env.getProperty("ds.minEvictableIdleTimeMillis"), 300000));
    ds.setValidationQuery(env.getProperty("ds.validationQuery"));
    ds.setTestWhileIdle(BooleanUtils.toBoolean(env.getProperty("ds.testWhileIdle")));
    ds.setTestOnBorrow(BooleanUtils.toBoolean(env.getProperty("ds.testOnBorrow")));
    ds.setTestOnReturn(BooleanUtils.toBoolean(env.getProperty("ds.testOnReturn")));
    ds.setPoolPreparedStatements(BooleanUtils.toBoolean(env.getProperty("ds.poolPreparedStatements")));
    ds.setMaxOpenPreparedStatements(NumberUtils.toInt(env.getProperty("ds.maxOpenPreparedStatements"), 20));
    return ds;
}
 
開發者ID:slking1987,項目名稱:mafia,代碼行數:25,代碼來源:DsSlaveConfig.java

示例7: dataSource

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean(initMethod="init",destroyMethod="close")
public DataSource dataSource(){
    DruidDataSource ds = new DruidDataSource();
    ds.setUrl(config.getUrl());
    ds.setUsername(config.getUsername());
    ds.setPassword(config.getPassword());
    ds.setInitialSize(ds.getInitialSize());
    ds.setMinIdle(config.getMinIdle());
    ds.setMaxActive(config.getMaxActive());
    ds.setMaxWait(config.getMaxWait());
    ds.setTimeBetweenEvictionRunsMillis(config.getTimeBetweenEvictionRunsMillis()); // 關閉檢測間隔 毫秒
    ds.setMinEvictableIdleTimeMillis(config.getMinEvictableIdleTimeMillis()); // 一個連接的最小生存時間
    ds.setValidationQuery("SELECT 'x'");
    ds.setTestWhileIdle(config.isTestWhileIdle());
    ds.setTestOnBorrow(config.isTestOnBorrow());
    ds.setTestOnReturn(config.isTestOnReturn());
    ds.setPoolPreparedStatements(config.isPoolPreparedStatements());
    ds.setMaxPoolPreparedStatementPerConnectionSize(config.getMaxPoolPreparedStatementPerConnectionSize());
    ds.setRemoveAbandoned(config.isRemoveAbandoned());
    ds.setRemoveAbandonedTimeout(config.getRemoveAbandonedTimeout());
    ds.setLogAbandoned(config.isLogAbandoned());
    ds.setTimeBetweenLogStatsMillis(config.getTimeBetweenLogStatsMillis());
    ds.setPhyTimeoutMillis(config.getPhyTimeoutMillis());
    ds.setMaxEvictableIdleTimeMillis(config.getMaxEvictableIdleTimeMillis());
    ds.setDbType("mysql");
    try {
        ds.setFilters("stat,slf4j");
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return ds ; 
}
 
開發者ID:eXcellme,項目名稱:eds,代碼行數:33,代碼來源:DatabaseConfig.java

示例8: dataSource

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
/**
 * database configuration
 */
@Bean(initMethod = "init", destroyMethod = "close")
public DataSource dataSource() {
    logger.debug("Configuring Datasource");

    DruidDataSource druidDataSource = new DruidDataSource();
    druidDataSource.setDriverClassName(driverClassName);
    druidDataSource.setUrl(url);
    druidDataSource.setUsername(username);
    druidDataSource.setPassword(password);
    druidDataSource.setMaxActive(maximumPoolSize);
    druidDataSource.setMaxWait(60000);
    druidDataSource.setMinIdle(1);
    druidDataSource.setValidationQuery("SELECT 1");
    druidDataSource.setTestWhileIdle(true);
    druidDataSource.setTestOnBorrow(false);
    druidDataSource.setTestOnReturn(false);
    /**
     * configuration exception handling
     * */
    druidDataSource.setQueryTimeout(15); //sql select max time : 15s
    //a connetion must be closed by removeAbandonedTimeout second
    druidDataSource.setRemoveAbandoned(true);
    druidDataSource.setRemoveAbandonedTimeout(600);
    druidDataSource.setLogAbandoned(true);
    return druidDataSource;
}
 
開發者ID:heikehuan,項目名稱:fly4j,代碼行數:30,代碼來源:DatabaseConfiguration.java

示例9: clusterDataSource

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean(name = "clusterDataSource")
public DataSource clusterDataSource() {
    DruidDataSource dataSource = new DruidDataSource();
    dataSource.setName("cluster");
    dataSource.setDriverClassName(driverClass);
    dataSource.setUrl(url);
    dataSource.setUsername(user);
    dataSource.setPassword(password);
    // 配置初始化大小、最小、最大
    dataSource.setInitialSize(0);
    dataSource.setMinIdle(0);
    dataSource.setMaxActive(10);
    // 配置獲取連接等待超時的時間
    dataSource.setMaxWait(15000);
    // 配置間隔多久才進行一次檢測,檢測需要關閉的空閑連接,單位是毫秒
    dataSource.setTimeBetweenEvictionRunsMillis(60000);
    // 配置一個連接在池中最小生存的時間,一個小時
    dataSource.setMinEvictableIdleTimeMillis(3600000);
    dataSource.setTestWhileIdle(true);
    // 這裏建議配置為TRUE,防止取到的連接不可用
    dataSource.setTestOnBorrow(true);
    dataSource.setTestOnReturn(false);
    // 這裏配置提交方式,默認就是TRUE,可以不用配置
    dataSource.setDefaultAutoCommit(true);
    // 驗證連接有效與否的SQL,不同的數據配置不同
    dataSource.setValidationQuery("SELECT 1");
    return dataSource;
}
 
開發者ID:zheng-zy,項目名稱:springboot-mybatis-druid-mutil-datasource,代碼行數:29,代碼來源:ClusterDataSourceConfig.java

示例10: dataSource

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean(initMethod = "init", destroyMethod = "close")
public DruidDataSource dataSource() throws SQLException {
    if (StringUtils.isEmpty(propertyResolver.getProperty("url"))) {
        System.out.println("Your database connection pool configuration is incorrect!"
                + " Please check your Spring profile, current profiles are:"
                + Arrays.toString(environment.getActiveProfiles()));
        throw new ApplicationContextException(
                "Database connection pool is not configured correctly");
    }
    DruidDataSource druidDataSource = new DruidDataSource();
    druidDataSource.setDriverClassName(propertyResolver.getProperty("driver-class-name"));
    druidDataSource.setUrl(propertyResolver.getProperty("url"));
    druidDataSource.setUsername(propertyResolver.getProperty("username"));
    druidDataSource.setPassword(propertyResolver.getProperty("password"));
    druidDataSource.setInitialSize(Integer.parseInt(propertyResolver.getProperty("initialSize")));
    druidDataSource.setMinIdle(Integer.parseInt(propertyResolver.getProperty("minIdle")));
    druidDataSource.setMaxActive(Integer.parseInt(propertyResolver.getProperty("maxActive")));
    druidDataSource.setMaxWait(Integer.parseInt(propertyResolver.getProperty("maxWait")));
    druidDataSource.setTimeBetweenEvictionRunsMillis(Long.parseLong(propertyResolver.getProperty("timeBetweenEvictionRunsMillis")));
    druidDataSource.setMinEvictableIdleTimeMillis(Long.parseLong(propertyResolver.getProperty("minEvictableIdleTimeMillis")));
    druidDataSource.setValidationQuery(propertyResolver.getProperty("validationQuery"));
    druidDataSource.setTestWhileIdle(Boolean.parseBoolean(propertyResolver.getProperty("testWhileIdle")));
    druidDataSource.setTestOnBorrow(Boolean.parseBoolean(propertyResolver.getProperty("testOnBorrow")));
    druidDataSource.setTestOnReturn(Boolean.parseBoolean(propertyResolver.getProperty("testOnReturn")));
    druidDataSource.setPoolPreparedStatements(Boolean.parseBoolean(propertyResolver.getProperty("poolPreparedStatements")));
    druidDataSource.setMaxPoolPreparedStatementPerConnectionSize(Integer.parseInt(propertyResolver.getProperty("maxPoolPreparedStatementPerConnectionSize")));
    druidDataSource.setFilters(propertyResolver.getProperty("filters"));
    return druidDataSource;
}
 
開發者ID:jmdhappy,項目名稱:xxpay-master,代碼行數:30,代碼來源:DruidDataSourceConfig.java

示例11: start

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
public boolean start() {
	ds = new DruidDataSource();
	
	ds.setUrl(url);
	ds.setUsername(username);
	ds.setPassword(password);
	ds.setDriverClassName(driverClass);
	ds.setInitialSize(initialSize);
	ds.setMinIdle(minIdle);
	ds.setMaxActive(maxActive);
	ds.setMaxWait(maxWait);
	ds.setTimeBetweenConnectErrorMillis(timeBetweenConnectErrorMillis);
	ds.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
	ds.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
	
	ds.setValidationQuery(validationQuery);
	ds.setTestWhileIdle(testWhileIdle);
	ds.setTestOnBorrow(testOnBorrow);
	ds.setTestOnReturn(testOnReturn);
	
	ds.setRemoveAbandoned(removeAbandoned);
	ds.setRemoveAbandonedTimeoutMillis(removeAbandonedTimeoutMillis);
	ds.setLogAbandoned(logAbandoned);
	
	//隻要maxPoolPreparedStatementPerConnectionSize>0,poolPreparedStatements就會被自動設定為true,參照druid的源碼
	ds.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
	
	if (StrKit.notBlank(filters))
		try {ds.setFilters(filters);} catch (SQLException e) {throw new RuntimeException(e);}
	
	addFilterList(ds);
	return true;
}
 
開發者ID:WhatAKitty,項目名稱:spark-project,代碼行數:34,代碼來源:DruidConfiguration.java

示例12: configDruid

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
private void configDruid(DruidDataSource dataSource, DruidProperties properties) {
    dataSource.setUrl(url);
    dataSource.setUsername(username);
    dataSource.setPassword(password);
    if (properties.getInitialSize() > 0) {
        dataSource.setInitialSize(properties.getInitialSize());
    }
    if (properties.getMinIdle() > 0) {
        dataSource.setMinIdle(properties.getMinIdle());
    }
    if (properties.getMaxActive() > 0) {
        dataSource.setMaxActive(properties.getMaxActive());
    }
    if (properties.getMaxWait() > 0 ){
        dataSource.setMaxWait(properties.getMaxWait());
    }
    if (properties.getTimeBetweenEvictionRunsMillis() > 0l){
        dataSource.setTimeBetweenEvictionRunsMillis(properties.getTimeBetweenEvictionRunsMillis());
    }
    if (properties.getMaxPoolPreparedStatementPerConnectionSize() > 0 ){
        dataSource.setMaxPoolPreparedStatementPerConnectionSize(properties.getMaxPoolPreparedStatementPerConnectionSize());
    }
    if (properties.getValidationQueryTimeout() > 0 ){
        dataSource.setValidationQueryTimeout(properties.getValidationQueryTimeout());
    }
    if (properties.getMinEvictableIdleTimeMillis() > 0l){
        dataSource.setMinEvictableIdleTimeMillis(properties.getMinEvictableIdleTimeMillis());
    }
    dataSource.setValidationQuery(properties.getValidationQuery());
    dataSource.setTestOnReturn(properties.getTestOnReturn());
    dataSource.setTestOnBorrow(properties.isTestOnBorrow());
    dataSource.setTestWhileIdle(properties.getTestWhileIdle());
    dataSource.setPoolPreparedStatements(properties.getPoolPreparedStatements());
    dataSource.setConnectProperties(properties.getConnectionProperties());
    try {
        dataSource.setFilters(properties.getFilters());
    } catch (SQLException e) {
        throw new IllegalArgumentException("please check your spring.datasource.druid.filters property.", e);
    }
}
 
開發者ID:cuisongliu,項目名稱:druid-boot-starter,代碼行數:41,代碼來源:DruidAutoConfiguration.java

示例13: register

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Override
public boolean register() {
    if (IsRegistered) {
        return HAS_REGISTERED;
    }

    DruidDataSource ds = new DruidDataSource();

    if (!StrUtil.isBlank(name)) {
        ds.setName(this.name);
    }

    ds.setUrl(jdbcURL);
    ds.setDriverClassName(jdbcDriver);
    ds.setUsername(jdbcUsername);
    ds.setPassword(jdbcPassword);

    ds.setMinIdle(minIdle);
    ds.setMaxActive(maxActive);
    ds.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
    ds.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
    ds.setValidationQuery(validationQuery);

    ds.setTestWhileIdle(testWhileIdle);
    ds.setTestOnBorrow(testOnBorrow);
    ds.setTestOnReturn(testOnReturn);

    setDataSource(ds);
    setIsRegistered(HAS_REGISTERED);
    return HAS_REGISTERED;
}
 
開發者ID:xujiajun,項目名稱:tastjava,代碼行數:32,代碼來源:DruidProvider.java

示例14: dataSource

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean
@Primary
public DataSource dataSource() {
  DruidDataSource datasource = new DruidDataSource();
  datasource.setUrl(this.dbUrl);
  datasource.setUsername(username);
  datasource.setPassword(password);
  datasource.setDriverClassName(driverClassName);
  // configuration
  datasource.setInitialSize(initialSize);
  datasource.setMinIdle(minIdle);
  datasource.setMaxActive(maxActive);
  datasource.setMaxWait(maxWait);
  datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
  datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
  datasource.setValidationQuery(validationQuery);
  datasource.setTestWhileIdle(testWhileIdle);
  datasource.setTestOnBorrow(testOnBorrow);
  datasource.setTestOnReturn(testOnReturn);
  datasource.setPoolPreparedStatements(poolPreparedStatements);
  datasource
      .setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
  try {
    datasource.setFilters(filters);
  } catch (SQLException e) {
    logger.error("druid configuration initialization filter", e);
  }
  datasource.setConnectionProperties(connectionProperties);

  return datasource;
}
 
開發者ID:venus-boot,項目名稱:saluki,代碼行數:32,代碼來源:DataSourceConfiguration.java

示例15: dataSource

import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean(initMethod = "init", destroyMethod = "close")
public DataSource dataSource() throws SQLException {
    if (StringUtils.isEmpty(datasourcePropertyResolver.getProperty("url"))) {
        System.out.println("Your database connection pool configuration is incorrect!" +
                " Please check your Spring profile, current profiles are:"+
                Arrays.toString(environment.getActiveProfiles()));
        throw new ApplicationContextException(
                "Database connection pool is not configured correctly");
    }
    DruidDataSource druidDataSource = new DruidDataSource();
    druidDataSource.setUrl(datasourcePropertyResolver.getProperty("url"));

    druidDataSource.setUsername(datasourcePropertyResolver
            .getProperty("username"));
    druidDataSource.setPassword(datasourcePropertyResolver
            .getProperty("password"));
    druidDataSource.setInitialSize(1);
    druidDataSource.setMinIdle(1);
    druidDataSource.setMaxActive(20);
    druidDataSource.setMaxWait(60000);
    druidDataSource.setTimeBetweenEvictionRunsMillis(60000);
    druidDataSource.setMinEvictableIdleTimeMillis(300000);
    druidDataSource.setValidationQuery("SELECT 'x'");
    druidDataSource.setTestWhileIdle(true);
    druidDataSource.setTestOnBorrow(false);
    druidDataSource.setTestOnReturn(false);
    return druidDataSource;
}
 
開發者ID:dragon-yuan,項目名稱:Ins_fb_pictureSpider_WEB,代碼行數:29,代碼來源:DatabaseConfiguration.java


注:本文中的com.alibaba.druid.pool.DruidDataSource.setTestWhileIdle方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台,相關代碼片段篩選自各路編程大神貢獻的開源項目,源碼版權歸原作者所有,傳播和使用請參考對應項目的License;未經允許,請勿轉載。