seata集成mybatis或者tkmybatis问题本地事物和全局事务冲突

1. 对于本地事物@transactional和全局事务冲突问题： 配置calss类需要加上以下配置：配置事务管理器数据源为seata数据代理

/**
     * spring事务配置数据源代理
     * @param dataSourceProxy
     * @return
     */
    @Bean
    @Primary
    public DataSourceTransactionManager dataSourceTransactionManager(DataSourceProxy dataSourceProxy){
        DataSourceTransactionManager transactionManager = new DataSourceTransactionManager();
        transactionManager.setDataSource(dataSourceProxy);
        return transactionManager;
    }

并且 factoryBean.setTransactionFactory(new SpringManagedTransactionFactory()); 必须配置成 SpringManagedTransactionFactory，因为mybatis默认用SpringManagedTransactionFactory

/**
     * 替换 mybatis 的sqlSessionFactory，用数据源代理替换自动装配的数据源
     * @Param: dataSourceProxy  fescar数据源代理
     * @Return: SqlSessionFactory  mybatic使用的数据源
     */
    @Bean
    public SqlSessionFactory sqlSessionFactory(DataSourceProxy dataSourceProxy) throws Exception {
        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        factoryBean.setDataSource(dataSourceProxy);
        factoryBean.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources("classpath*:/mapper/*.xml"));
//        factoryBean.setTransactionFactory(new JdbcTransactionFactory());  //这个不可用
        factoryBean.setTransactionFactory(new SpringManagedTransactionFactory());
        org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        configuration.setMapUnderscoreToCamelCase(true);
        factoryBean.setConfiguration(configuration);
        return factoryBean.getObject();
    }

1. 对于返回自增id是undo_log的自增id，解决方案如下： 可以在生成的xml文件的insert加上： useGeneratedKeys="true" keyProperty="id"

//tkmybatis的话需要在生成的映射对象类的id上配置generator = "JDBC"如下：
@Table(name = "xxx_credit_apply")
@Setter
@Getter
public class XxxCreditApplyPo {
    @Id
    @GeneratedValue(generator = "JDBC")
    private Long id;
}