springCloud 不同数据库类型的多数据源配置

1、在配置文件中加入多数据源信息(不同数据库类型,pom文件中要引入相对应的数据库驱动)

datasource:
    local:
      jdbc-url: jdbc:postgresql://ip:port/cpic?currentSchema=*********
      username: *********
      password: *********
    gpt:
      driver-class-name: oracle.jdbc.OracleDriver
      jdbc-url: jdbc:oracle:thin:@ip:port:orcl
      username: *********
      password: *********
    ott:
      driver-class-name: oracle.jdbc.OracleDriver
      jdbc-url: jdbc:oracle:thin:@ip:port:orcl
      username: *********
      password: *********
    mf:
      driver-class-name: oracle.jdbc.OracleDriver
      jdbc-url: jdbc:oracle:thin:@ip:port:orcl
      username: *********
      password: *********

2、添加配置类(@MapperScan),如上图需要建四个配置类,这里拿一个举例

@Configuration
@MapperScan(basePackages = "com.clamc.collection.mapper.mf", sqlSessionFactoryRef = "mfSqlSessionFactory",
    sqlSessionTemplateRef = "mfSqlSessionTemplate")
public class MfDataSourceConfig {
    @Bean("mfDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.mf") //读取application.yml中的配置参数映射成为一个对象
    public DataSource getmfDataSource(){
        return DataSourceBuilder.create().build();
    }

    @Bean("mfSqlSessionFactory")
    public SqlSessionFactory mfSqlSessionFactory(@Qualifier("mfDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        // mapper的xml形式文件位置必须要配置,不然将报错:no statement (这种错误也可能是mapper的xml中,namespace与项目的路径不一致导致)
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/mf/*.xml"));
        return bean.getObject();
    }

    @Bean("mfSqlSessionTemplate")
    public SqlSessionTemplate mfSqlSessionTemplate(@Qualifier("mfSqlSessionFactory") SqlSessionFactory sqlSessionFactory){
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}

指定要读的mapper路径即可,项目路径如下:

springCloud 不同数据库类型的多数据源配置

 

 

上一篇:Linux分配home容量给根目录


下一篇:AttributeError: 'str' object has no attribute 'decode'