springboot切库失败解决过程分析

1. 报错误：

Field masterDB in DataSourceConfig.MybatisConfig required a single bean, but 3 were found:

- masterDB: defined by method 'dataSource' in class path resource 

- slaveDB: defined by method 'dataSourceSlave' in class path resource 

- dynamicDataSource: defined by method 'dynamicDataSource' in class path resource 

2.我的解决方法：

首先在springboot上配置

@SpringBootApplication(exclude= {

DataSourceAutoConfiguration.class

})

3.后台报错：

No qualifying bean of type 'transaction.PlatformTransactionManager' available

解决方法：

在配置动态数据源的类:Mybatisconfig.java中加入事务管理。

@Bean

    public DataSourceTransactionManager transactitonManager(){

        return new DataSourceTransactionManager(dynamicDataSource());

    }

4.我这样配置后不报错了。报错也没问题：

插入库后，用int a = 1/0;报异常测试事务回滚正常。