DataBaseConfig中加入事务管理器 

DataBaseConfig的详解以及多数据源的配置参见我的上一篇文章

@Configuration@MapperScan(basePackages={"com.sc.myboot.dao"},sqlSessionFactoryRef = "MySqlSessionFactory1")public class DataBaseConfig {        @Value("${spring.datasource.type}")    private Class
      dataSourceType;        @Bean(name = "MyDataSource1")    @ConfigurationProperties(prefix = "data2")    public DataSource getDataSource(){        return DataSourceBuilder.create().type(dataSourceType).build();    }        @Bean(name = "Data1TransactionManager1")    public DataSourceTransactionManager masterTransactionManager() {        return new DataSourceTransactionManager(getDataSource());    }         @Bean(name = "MySqlSessionFactory1")    public SqlSessionFactory masterSqlSessionFactory(@Qualifier("MyDataSource1") DataSource masterDataSource)            throws Exception {        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();        sessionFactory.setDataSource(masterDataSource);        return sessionFactory.getObject();    }}

 

在Service的方法中使用注解@Transactional

在多数据源编程的情况下一定要配置多事务管理器，即一个数据源对应一个事务管理器