易语言可以做网站管理系统吗,win7 iis添加网站,学校网站建设经验介绍,淄博手机网站建设费用当某些sql因为不知名原因堵塞时#xff0c;为了不影响后台服务运行#xff0c;想要给sql增加执行时间限制#xff0c;超时后就抛异常#xff0c;保证后台线程不会因为sql堵塞而堵塞。
方法一
yml全局配置#xff1a;单数据源可以#xff0c;多数据源时会失效 方法二
j…当某些sql因为不知名原因堵塞时为了不影响后台服务运行想要给sql增加执行时间限制超时后就抛异常保证后台线程不会因为sql堵塞而堵塞。
方法一
yml全局配置单数据源可以多数据源时会失效 方法二
java配置类配置成功抛出超时异常。
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;import javax.sql.DataSource;Configuration
MapperScan(basePackages top.oldmoon.bill.mapper, sqlSessionFactoryRef sqlSessionFactory)
public class DBConfiguration {PrimaryBean(name dataSource)ConfigurationProperties(prefix spring.datasource)public DataSource gfDataSource() {DruidDataSource dataSource DruidDataSourceBuilder.create().build();return dataSource;}PrimaryBean(name sqlSessionFactory)public SqlSessionFactory gfSqlSessionFactory(Qualifier(dataSource) DataSource dataSource) throws Exception {SqlSessionFactoryBean factoryBean new SqlSessionFactoryBean();factoryBean.setDataSource(dataSource);factoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(classpath:mybatis/*.xml));org.apache.ibatis.session.Configuration configuration new org.apache.ibatis.session.Configuration();configuration.setDefaultStatementTimeout(1); // 设置sql执行超时时间秒factoryBean.setConfiguration(configuration);SqlSessionFactory sqlSessionFactory factoryBean.getObject();return sqlSessionFactory;}PrimaryBean(name transactionManager)public DataSourceTransactionManager gfTransactionManager(Qualifier(dataSource) DataSource dataSource) {return new DataSourceTransactionManager(dataSource);}PrimaryBean(name sqlSessionTemplate)public SqlSessionTemplate gfSqlSessionTemplate(Qualifier(sqlSessionFactory) SqlSessionFactory sqlSessionFactory) throws Exception {SqlSessionTemplate sqlSessionTemplate new SqlSessionTemplate(sqlSessionFactory);return sqlSessionTemplate;}
}Fri Mar 12 15:56:31 CST 2022--方法开始执行
2022-03-12 15:56:38.508 ERROR 24484 --- [nio-8111-exec-3] o.api.advice.ExceptionHandlerAdvice : 未知异常
### Error querying database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or client request
### The error may exist in file [E:\space-persional\git\oldmoon-frame\oldmoon-app-bill\out\production\resources\mybatis\UserMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select * from V_BGD_PWGM_PB_21
### Cause: com.mysql.cj.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or client request
; Statement cancelled due to timeout or client request; nested exception is com.mysql.cj.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or client request
org.springframework.dao.QueryTimeoutException: {resultCode: 2,resultMsg: 未知异常请联系管理员,token: null,resultInfo: \r\n### Error querying database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or client request\r\n### The error may exist in file ................
}
