Spring Boot + mybatis 多数据源配置

2018-03-27 10:54:45 557 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Spring Boot MyBatis配置Druid多数据源，Java开发自学教程千千万万要记得：多刷题！！多刷题！！之前算法是我的硬伤，后面硬啃了好长一段时间才补回来，算法才是程序员的灵魂！！！！篇幅有限，以下只能截图分享部分的资源！！（1）多线程（这里以多线程为代表，其实整理了一本JAVA核心架构笔记集）（2）刷的算法题（还有左神的算法笔记）（3）面经+真题解析+对应的相关笔记（很全面）（4）视频学习（部分）ps：当你觉得学不进或者累了的时候，视频是个不错的选择在这里，最后只一句话：祝大家offer拿到手软！！一个人可以走的很快，但一群人才能走的更远。阅读详情

我根据网上的文章配置的多数据源，在查询标有Primary注解的数据源时一切正常，但查非Primary的数据源时会抛出异常，查了很久不知道什么原因，大佬们帮忙看看原因啊！！
代码贴出来





@Configuration

@MapperScan(basePackages = {"com.demo.clp.db.company.repository"}, sqlSessionTemplateRef = "companyDbSessionTemplate")

public class CompanyDbConfig {



    @Value("${spring.datasource.companydb.url}")

    private String companyDbUrl;

    @Value("${spring.datasource.companydb.username}")

    private String companyDbUsername;

    @Value("${spring.datasource.companydb.password}")

    private String companyDbPassword;

    @Value("${spring.datasource.companydb.driver-class-name}")

    private String companyDbDriver;



    @Bean(name = "companyDbDataSource")

    @Primary

    public DataSource companyDbDataSource(){

        DataSourceBuilder companyDataSourceBuilder = DataSourceBuilder.create();

        companyDataSourceBuilder.username(companyDbUsername);

        companyDataSourceBuilder.password(PwdUtil.decryptString(companyDbPassword,PwdUtil.pwd));

        companyDataSourceBuilder.url(companyDbUrl);

        companyDataSourceBuilder.driverClassName(companyDbDriver);

        return companyDataSourceBuilder.build();

    }



    @Bean(name = "companyDbSessionFactory")

    @Primary

    public SqlSessionFactory companyDbSessionFactory() throws Exception{

        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();

        factoryBean.setDataSource(companyDbDataSource());

        factoryBean.setMapperLocations(new PathMatchingResourcePatternResolver()

                .getResources("classpath:templates/com/demo/clp/db/company/mapper/*.xml"));

        return factoryBean.getObject();

    }



    @Bean(name = "companyDbSessionTemplate")

    @Primary

    public SqlSessionTemplate companyDbSessionTemplate() throws Exception{

        SqlSessionTemplate template = new SqlSessionTemplate(companyDbSessionFactory());

        return template;

    }



    @Bean(name = "companyDbTransactionManager")

    @Primary

    public DataSourceTransactionManager companyDbTransactionManager(){

        return new DataSourceTransactionManager(companyDbDataSource());

    }

}



@Configuration

@MapperScan(basePackages = {"com.demo.clp.db.member.repository"},sqlSessionTemplateRef = "memberDbSessionTemplate")

public class MemberDbConfig {



    @Value("${spring.datasource.memberdb.url}")

    private String memberDbUrl;

    @Value("${spring.datasource.memberdb.username}")

    private String memberDbUsernam;

    @Value("${spring.datasource.memberdb.password}")

    private String memberDbPassword;

    @Value("${spring.datasource.memberdb.driver-class-name}")

    private String memberDbDriver;



    @Bean(name = "memberDbDataSource")

//    @Primary

    public DataSource memberDbDataSource(){

        DataSourceBuilder memberDataSourceBuilder = DataSourceBuilder.create();

        memberDataSourceBuilder.username(memberDbUsernam);

        memberDataSourceBuilder.password(PwdUtil.decryptString(memberDbPassword,PwdUtil.pwd));

        memberDataSourceBuilder.url(memberDbUrl);

        memberDataSourceBuilder.driverClassName(memberDbDriver);

        return memberDataSourceBuilder.build();

    }



    @Bean(name = "memberDbSessionFactory")

//    @Primary

    public SqlSessionFactory memberDbSessionFactory() throws Exception{

        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();

        factoryBean.setDataSource(memberDbDataSource());

        factoryBean.setMapperLocations(new PathMatchingResourcePatternResolver()

                .getResources("classpath:templates/com/demo/clp/db/member/mapper/*.xml"));

        return factoryBean.getObject();

    }



    @Bean(name = "memberDbSessionTemplate")

//    @Primary

    public SqlSessionTemplate memberDbSessionTemplate() throws Exception{

        SqlSessionTemplate template = new SqlSessionTemplate(memberDbSessionFactory());

        return template;

    }



    @Bean(name = "memberDbTransactionManager")

//    @Primary

    public DataSourceTransactionManager memberDbTransactionManager(){

        return new DataSourceTransactionManager(memberDbDataSource());

    }

}

这是查询非Primary的方法



public Wifi queryRecord(String key) {

        Wifi example = new WifiExample();

        example.createCriteria()

                .andKeyEqualTo(key);

        List<Wifi> list = wifiMapper.selectByExample(example);

        Optional<Wifi> wifiOpt = list.stream()

                .sorted((a, b) -> b.getModifiedOn().compareTo(a.getModifiedOn()))

                .findFirst();

        if (wifiOpt .isPresent())

            return wifiOpt.get();

        return null;

    }

报错内容如下：



org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error invoking SqlProvider method (tk.mybatis.mapper.provider.ExampleProvider.dynamicSQL).  Cause: java.lang.InstantiationException: tk.mybatis.mapper.provider.ExampleProvider

用的mybatis generator生成的相关代码，Primary查询是正常的，非Primary报异常，很蛋疼！

...全文