本文整理匯總了Java中com.alibaba.druid.pool.DruidDataSource.setTestOnReturn方法的典型用法代碼示例。如果您正苦於以下問題：Java DruidDataSource.setTestOnReturn方法的具體用法？Java DruidDataSource.setTestOnReturn怎麽用？Java DruidDataSource.setTestOnReturn使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類com.alibaba.druid.pool.DruidDataSource的用法示例。
在下文中一共展示了DruidDataSource.setTestOnReturn方法的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()));
}
示例2: 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));
}
示例3: dataSource
import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean(initMethod = "init", destroyMethod = "close")
public DruidDataSource dataSource(DruidConfig druidConfig) throws IOException {
DruidDataSource ds = new DruidDataSource();
ds.setDriverClassName("com.mysql.cj.jdbc.Driver");
ds.setUrl(druidConfig.getUrl() + "?" + druidConfig.getOptions());
ds.setUsername(druidConfig.getUser());
ds.setPassword(druidConfig.getPwd());
ds.setInitialSize(druidConfig.getInitialSize());
ds.setMinIdle(druidConfig.getMinIdle());
ds.setMaxActive(druidConfig.getMaxActive());
ds.setMaxWait(druidConfig.getMaxWait());
ds.setTimeBetweenEvictionRunsMillis(druidConfig.getTimeBetweenEvictionRunsMillis());
ds.setMinEvictableIdleTimeMillis(druidConfig.getMinEvictableIdleTimeMillis());
ds.setValidationQuery(druidConfig.getValidationQuery());
ds.setTestWhileIdle(druidConfig.getTestWhileIdle());
ds.setTestOnBorrow(druidConfig.getTestOnBorrow());
ds.setTestOnReturn(druidConfig.getTestOnReturn());
return ds;
}
示例4: 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 ;
}
示例5: mysqlDataSource
import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
public DataSource mysqlDataSource() throws Exception{
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setUrl(this.url);
druidDataSource.setUsername(this.username);
druidDataSource.setPassword(this.password);
druidDataSource.setDriverClassName(this.driverClassName);
druidDataSource.setInitialSize(this.initialSize);
druidDataSource.setMaxActive(this.maxActive);
druidDataSource.setMinIdle(this.minIdle);
druidDataSource.setMaxWait(this.maxWait);
druidDataSource.setTimeBetweenEvictionRunsMillis(this.timeBetweenEvictionRunsMillis);
druidDataSource.setMinEvictableIdleTimeMillis(this.minEvictableIdleTimeMillis);
druidDataSource.setValidationQuery(this.validationQuery);
druidDataSource.setTestWhileIdle(this.testWhileIdle);
druidDataSource.setTestOnBorrow(this.testOnBorrow);
druidDataSource.setTestOnReturn(this.testOnReturn);
druidDataSource.setPoolPreparedStatements(this.poolPreparedStatements);
druidDataSource.setMaxPoolPreparedStatementPerConnectionSize(this.maxPoolPreparedStatementPerConnectionSize);
druidDataSource.setFilters(this.filters);
try {
druidDataSource.setFilters("wall,stat");
druidDataSource.setUseGlobalDataSourceStat(true);
druidDataSource.init();
} catch (Exception e) {
throw new RuntimeException("load datasource error, dbProperties is :", e);
}
return druidDataSource;
}
示例6: init
import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
public void init() throws Exception{
System.out.println("**************init");
MicroMetaDao dao=MicroMetaDao.getInstance();
String sql="select * from nh_micro_dbconf";
List<Map<String,Object>> infoList=dao.queryObjJoinByCondition(sql);
for(Map<String,Object> row:infoList){
String metaKey=(String) row.get("meta_key");
String dataSourceClassName=(String) row.get("datasource_classname");
String dbUser=(String) row.get("db_user");
String dbPassWord=(String) row.get("db_password");
if(dbPassWord.startsWith("nhjm-")){
String temp=dbPassWord.substring(5);
dbPassWord=DESUtil.decrypt(temp);
}
String dbUrl=(String) row.get("db_url");
DruidDataSource ds=new DruidDataSource();
ds.setUsername(dbUser);
ds.setPassword(dbPassWord);
ds.setUrl(dbUrl);
ds.setFilters("stat");
ds.setMaxActive(10);
ds.setInitialSize(1);
ds.setMaxWait(60000);
ds.setMinIdle(1);
ds.setTimeBetweenEvictionRunsMillis(60000);
ds.setMinEvictableIdleTimeMillis(60000);
ds.setValidationQuery("SELECT 'x'");
ds.setTestWhileIdle(true);
ds.setTestOnBorrow(false);
ds.setTestOnReturn(false);
ds.setPoolPreparedStatements(true);
ds.setMaxPoolPreparedStatementPerConnectionSize(10);
ds.setDriverClassName(dataSourceClassName);
ds.init();
JdbcTemplate jdbcTemplate=new JdbcTemplate();
jdbcTemplate.setDataSource(ds);
MicroDbHolder.getDbHolder().put(metaKey, jdbcTemplate);
}
}
示例7: businessDataSource
import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean(initMethod = "init", destroyMethod = "close")
@Primary
public DruidDataSource businessDataSource() throws SQLException, DESException {
DruidDataSource druidDataSource = new DruidDataSource();
druidDataSource.setDriverClassName(dbConfigProperties.getDriveClass());
druidDataSource.setUrl(dbConfigProperties.getBusinessUrl());
druidDataSource.setUsername(dbConfigProperties.getBusinessUsername());
druidDataSource.setPassword(dbConfigProperties.getBusinessPassword());
druidDataSource.setInitialSize(dbConfigProperties.getInitialSize());
druidDataSource.setMinIdle(dbConfigProperties.getMinIdle());
druidDataSource.setMaxActive(dbConfigProperties.getMaxActive());
druidDataSource.setMaxWait(dbConfigProperties.getMaxWait());
druidDataSource.setTimeBetweenEvictionRunsMillis(dbConfigProperties.getTimeBetweenEvictionRunsMillis());
druidDataSource.setMinEvictableIdleTimeMillis(dbConfigProperties.getMinEvictableIdleTimeMillis());
//此項如果為空，下麵幾個test都不會生效
druidDataSource.setValidationQuery(dbConfigProperties.getValidationQuery());
druidDataSource.setTestWhileIdle(dbConfigProperties.getTestWhileIdle());
druidDataSource.setTestOnBorrow(dbConfigProperties.getTestOnBorrow());
druidDataSource.setTestOnReturn(dbConfigProperties.getTestOnReturn());
//5.5以後的mysql開啟，以後的關閉
druidDataSource.setPoolPreparedStatements(dbConfigProperties.getPoolPreparedStatements());
druidDataSource.setMaxPoolPreparedStatementPerConnectionSize(dbConfigProperties.getMaxPoolPreparedStatementPerConnectionSize());
druidDataSource.setFilters(dbConfigProperties.getFilters());
return druidDataSource;
}
示例8: 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;
}
示例9: initDataSource
import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
private void initDataSource(){
dataSource=new DruidDataSource();
dataSource.setAsyncCloseConnectionEnable(true);
dataSource.setBreakAfterAcquireFailure(true);
dataSource.setDefaultAutoCommit(true);
dataSource.setDefaultReadOnly(true);
dataSource.setDriverClassName(args.getJdbcDriver());
dataSource.setEnable(true);
dataSource.setPassword(args.getPassword());
dataSource.setTestOnBorrow(true);
dataSource.setTestOnReturn(true);
dataSource.setTestWhileIdle(true);
dataSource.setUrl(args.getJdbcUrl());
dataSource.setUsername(args.getUser());
}
示例10: 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
示例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;
}
示例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);
}
}
示例13: dataSource
import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean //聲明其為Bean實例
@Primary //在同樣的DataSource中，首先使用被標注的DataSource
public DataSource dataSource() {
DruidDataSource datasource = new DruidDataSource();
datasource.setUrl(url);
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;
}
示例14: 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;
}
示例15: dataSource
import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
@Bean
@Primary
public DataSource dataSource() {
DruidDataSource datasource = new DruidDataSource();
datasource.setUrl(url);
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) {
System.err.println("druid configuration initialization filter: " + e);
}
datasource.setConnectionProperties(connectionProperties);
return datasource;
}