本文整理汇总了Java中com.alibaba.druid.pool.DruidDataSource.setDefaultAutoCommit方法的典型用法代码示例。如果您正苦于以下问题:Java DruidDataSource.setDefaultAutoCommit方法的具体用法?Java DruidDataSource.setDefaultAutoCommit怎么用?Java DruidDataSource.setDefaultAutoCommit使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类com.alibaba.druid.pool.DruidDataSource
的用法示例。
在下文中一共展示了DruidDataSource.setDefaultAutoCommit方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: 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());
}
示例2: 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
示例3: masterDataSource
import com.alibaba.druid.pool.DruidDataSource; //导入方法依赖的package包/类
@Bean(name = "masterDataSource")
@Primary
public DataSource masterDataSource() {
DruidDataSource dataSource = new DruidDataSource();
dataSource.setName("master");
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,代码行数:30,代码来源:MasterDataSourceConfig.java
示例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;
}