mybatis-plus配置多数据源出现invalid bound statement not found怎么解决

本篇内容介绍了"mybatis-plus配置多数据源出现invalid bound statement not found怎么解决"的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

一、 环境

1. 版本号

        com.baomidou     mybatis-plus-boot-starter     3.2.0

   
   

2. 没有使用myabtis-plus的多数据源依赖

       com.baomidou    dynamic-datasource-spring-boot-starter    2.5.7

   
   

二、 多数据源配置

1. 启动类配置

   @MapperScans({        @MapperScan(basePackages = {"com.aaa.dao"}, sqlSessionFactoryRef = DatasourceConf.SESSION_FACTORY),        @MapperScan(basePackages = {"com.bbb.dao"}, sqlSessionFactoryRef = OtherDatasourceConf.OTHER_SESSION_FACTORY)})

   
   

2. 配置类

   @Configurationpublic class DatasourceConf {    public static final String SESSION_FACTORY = "SessionFactory";    @Primary    @Bean(name = SESSION_FACTORY)    public SqlSessionFactory dianOrderSessionFactory(MybatisProperties properties) throws Exception {                SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();        sqlSessionFactoryBean.setDataSource(secondDatasource());        //...    }    @Primary    @Bean    public DataSource secondDatasource() {        return new HikariDataSource(secondHikariConfig());    }    @Bean    @ConfigurationProperties(prefix = "spring.datasource.aaa.hikari")    public HikariConfig secondHikariConfig() {        return new HikariConfig();    }}

   
   

   另一个数据源配置

   @Configurationpublic class OtherDatasourceConf {    public static final String OTHER_SESSION_FACTORY = "otherSessionFactory";    @Bean(name = OTHER_SESSION_FACTORY)    public SqlSessionFactory otherSessionFactory(MybatisProperties properties) throws Exception {                SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();        sqlSessionFactoryBean.setDataSource(otherDataSource());        //....    }    @Bean    public DataSource otherDataSource() {        return new HikariDataSource(otherHikariConfig());    }    @Bean    @ConfigurationProperties(prefix = "spring.datasource.hikari")    public HikariConfig otherHikariConfig() {        return new HikariConfig();    }}

   
   

三、异常

在mapper.xml中配置了sql的都没问题，但是使用mybatis-plus的内置函数就会报invalid bound statement (not found)异常。

四、 解决

1. 查看MybatisPlusAutoConfiguration类

   @Configuration@ConditionalOnClass({SqlSessionFactory.class, SqlSessionFactoryBean.class})@ConditionalOnSingleCandidate(DataSource.class)@EnableConfigurationProperties(MybatisPlusProperties.class)@AutoConfigureAfter(DataSourceAutoConfiguration.class)public class MybatisPlusAutoConfiguration implements InitializingBean {    @Bean    @ConditionalOnMissingBean    public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {        // TODO 使用 MybatisSqlSessionFactoryBean 而不是 SqlSessionFactoryBean        MybatisSqlSessionFactoryBean factory = new MybatisSqlSessionFactoryBean();        factory.setDataSource(dataSource);                ...        return factory.getObject();    }}

   
   

2. 将SqlSessionFactoryBean修改成myabtis-plus自定义的MybatisSqlSessionFactoryBean解决

3. 注意mybatis-plus的配置需要使用MybatisPlusProperties而不是MybatisProperties

4. 当配置类多个DataSource，MybatisPlusAutoConfiguration类就不再生效，需要手动配置

"mybatis-plus配置多数据源出现invalid bound statement not found怎么解决"的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注网站，小编将为大家输出更多高质量的实用文章！