1. 报错信息:
使用Seata解决分布式事务超时异常时,添加了@GlobalTransactional后,怎么也不生效
2. 原因分析:
1、以为 MyBatisConfig、DataSourceProxyConfig这些都是无用的,直接让自动配置类配置不就好了,结果是大意了,然我找了好久的问题,这里的DataSourceProxy是Seata数据源代理类
2、Seata 代理数据源 import io.seata.rm.datasource.DataSourceProxy
3、MyBatisConfig 中 @MapperScan({“com.atguigu.springcloud.Dao”}) 是必要的
4、因为新加载了 一个SqlSessionFactory组件,这个会使系统扫描不到 Dao,会报如下错误:
5、需要对 mybatis 进行配置,让其能扫描到 Dao
3. 解决方法:
添加 MyBatisConfig、DataSourceProxyConfig两个配置类
@Configuration
@MapperScan("com.xxx.springcloud.dao")
public class MyBatisConfig {
}
import com.alibaba.druid.pool.DruidDataSource;
import io.seata.rm.datasource.DataSourceProxy;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.transaction.SpringManagedTransactionFactory;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import javax.sql.DataSource;
@Configuration
public class DataSourceProxyConfig {
@Value("${mybatis.mapperLocations}")
private String mapperLocations;
@Bean
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource druidDataSource(){
return new DruidDataSource();
}
@Bean
public DataSourceProxy dataSourceProxy(DataSource dataSource) {
return new DataSourceProxy(dataSource);
}
@Bean
public SqlSessionFactory sqlSessionFactoryBean(DataSourceProxy dataSourceProxy) throws Exception {
SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
sqlSessionFactoryBean.setDataSource(dataSourceProxy);
sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations));
sqlSessionFactoryBean.setTransactionFactory(new SpringManagedTransactionFactory());
return sqlSessionFactoryBean.getObject();
}
}
最后,问题解决,成功回滚