本文整理匯總了Java中com.alibaba.druid.pool.DruidDataSource.setRemoveAbandoned方法的典型用法代碼示例。如果您正苦於以下問題:Java DruidDataSource.setRemoveAbandoned方法的具體用法?Java DruidDataSource.setRemoveAbandoned怎麽用?Java DruidDataSource.setRemoveAbandoned使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類com.alibaba.druid.pool.DruidDataSource
的用法示例。
在下文中一共展示了DruidDataSource.setRemoveAbandoned方法的4個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的Java代碼示例。
示例1: 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 ;
}
示例2: 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;
}
示例3: 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;
}
示例4: createDataSource
import com.alibaba.druid.pool.DruidDataSource; //導入方法依賴的package包/類
public DruidDataSource createDataSource() throws SQLException {
DruidDataSource dataSource = new DruidDataSource();
dataSource.setUrl(url);
dataSource.setUsername(username);
dataSource.setPassword(password);
dataSource.setDriverClassName(driverClassName);
dataSource.setConnectProperties(connectProperties);
dataSource.setInitialSize(initialSize);
dataSource.setMinIdle(minIdle);
dataSource.setMaxActive(maxActive);
dataSource.setMaxWait(maxWait);
dataSource.setFilters(filters);
dataSource.setDefaultAutoCommit(defaultAutoCommit);
dataSource.setTimeBetweenConnectErrorMillis(timeBetweenConnectErrorMillis);
dataSource.setValidationQuery(validationQuery);
dataSource.setValidationQueryTimeout(validationQueryTimeout);
dataSource.setTestWhileIdle(testWhileIdle);
dataSource.setTestOnBorrow(testOnBorrow);
dataSource.setTestOnReturn(testOnReturn);
dataSource.setPoolPreparedStatements(poolPreparedStatements);
dataSource.setClearFiltersEnable(clearFiltersEnable);
dataSource.setDefaultReadOnly(defaultReadOnly);
dataSource.setAsyncCloseConnectionEnable(asyncCloseConnectionEnable);
dataSource.setConnectionErrorRetryAttempts(connectionErrorRetryAttempts);
dataSource.setBreakAfterAcquireFailure(breakAfterAcquireFailure);
dataSource.setDupCloseLogEnable(dupCloseLogEnable);
dataSource.setEnable(enable);
dataSource.setLogAbandoned(logAbandoned);
dataSource.setLogDifferentThread(logDifferentThread);
dataSource.setLoginTimeout(loginTimeout);
dataSource.setAccessToUnderlyingConnectionAllowed(accessToUnderlyingConnectionAllowed);
dataSource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
dataSource.setQueryTimeout(queryTimeout);
dataSource.setFailFast(failFast);
dataSource.setMaxCreateTaskCount(maxCreateTaskCount);
dataSource.setRemoveAbandoned(removeAbandoned);
dataSource.setRemoveAbandonedTimeoutMillis(removeAbandonedTimeoutMillis);
dataSource.setDefaultTransactionIsolation(defaultTransactionIsolation);
dataSource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
dataSource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
dataSource.setMaxEvictableIdleTimeMillis(maxEvictableIdleTimeMillis);
dataSource.setMaxOpenPreparedStatements(maxOpenPreparedStatements);
dataSource.setNotFullTimeoutRetryCount(notFullTimeoutRetryCount);
dataSource.setTimeBetweenLogStatsMillis(timeBetweenLogStatsMillis);
return dataSource;
}