数据库配置

oracle

@Configuration
@MapperScan(basePackages = "com.inesa.HistoryData.mapper.oracle", sqlSessionFactoryRef = "SecondSqlSessionFactory")
public class DataSourceOracleConfig {

    @Bean(name = "SecondDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.oracle")
    public DataSource getPrimaryDataSource() {

        return DataSourceBuilder.create().build();
    }

    @Bean(name = "SecondSqlSessionFactory")
    @Qualifier
    public SqlSessionFactory sqlServerSqlSessionFactory(@Qualifier("SecondDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource);
        return sqlSessionFactoryBean.getObject();
    }

    @Bean("SecondSqlSessionTemplate")
    public SqlSessionTemplate sqlSessionTemplate(@Qualifier("SecondSqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}

sqlserver

@Configuration
@MapperScan(basePackages = "com.inesa.HistoryData.mapper.sqlserver", sqlSessionFactoryRef = "PrimarySqlSessionFactory")
public class DataSourceSqlServerConfig {

    @Bean(name = "PrimaryDataSource")
    @Primary
    @ConfigurationProperties(prefix = "spring.datasource.sqlserver")
    public DataSource getPrimaryDataSource() {

        return DataSourceBuilder.create().build();
    }

    @Bean(name = "PrimarySqlSessionFactory")
    @Primary
    @Qualifier
    public SqlSessionFactory sqlServerSqlSessionFactory(@Qualifier("PrimaryDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource);
        return sqlSessionFactoryBean.getObject();
    }

    @Bean("PrimarySqlSessionTemplate")
    @Primary
    public SqlSessionTemplate sqlSessionTemplate(@Qualifier("PrimarySqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}

yml文件