mybatisplus和mybatis兼容问题

Invalid bound statement (not found) 错误

原xml配置

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="mapperLocations" value="classpath:/META-INF/mapper/*.xml"/>
        <property name="configLocation" value="classpath:/META-INF/mybatis.xml"/>
        <property name="typeAliasesPackage" value="com.huobi.local.domain"/>
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.huobi.local.dao,com.huobi.local.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

构建SqlSessionFactory必须使用MybatisPlust实现的MybatisSqlSessionFactoryBean对象，否则mybatisPlus的一些特性会丢失, 自带的增删改查方法用不了。

替换为

<bean id="sqlSessionFactory" class="com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean">
        <property name="mapperLocations">
        <array>
            <value>classpath:/META-INF/mapper/*.xml</value>
            <value>classpath*:/mapper/**Mapper.xml</value>
        </array>
        </property>
        <property name="configLocation" value="classpath:/META-INF/mybatis.xml"/>
        <property name="typeAliasesPackage" value="com.huobi.local.domain"/>
        <property name="dataSource" ref="dataSource"/>
        <!--分页插件配置-->
        <property name="plugins">
            <array>
                <ref bean="mybatisPlusInterceptor"/>
            </array>
        </property>
    </bean>
    
    <bean id="mybatisPlusInterceptor" class="com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor">
        <property name="interceptors">
            <list>
                <ref bean="paginationInnerInterceptor"/>
            </list>
        </property>
    </bean>

    <bean id="paginationInnerInterceptor" class="com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor">
        <constructor-arg name="dbType" value="MYSQL"/>
        <property name="dbType" value="MYSQL" />
        <property name="maxLimit" value="-1" />
        <property name="optimizeJoin" value="true" />
    </bean>

    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.huobi.local.dao,com.huobi.local.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>