【已解决】Invalid bound statement (not found)

报错讯息

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.casey.mapper.SysRoleMapper.getUserRoleCode
at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235)[mybatis-\mathrm{3.5.4.}jar:\mathrm{3.5.4}]atcom.baomidou.mybatisplus.core.override.MybatisMapperMethod.<init>(MybatisMapperMethod.java:50)[mybatis-plus-core-\mathrm{3.3.2.}jar:\mathrm{3.3.2}]atcom.baomidou.mybatisplus.core.override.MybatisMapperProxy.lambda$cachedMapperMethod$0(MybatisMapperProxy.java:101)[mybatis-plus-core-\mathrm{3.3.2.}jar:\mathrm{3.3.2}]atjava.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)[na:\mathrm{1.8.}{0}_{2}91]atcom.baomidou.mybatisplus.core.override.MybatisMapperProxy.cachedMapperMethod(MybatisMapperProxy.java:100)[mybatis-plus-core-\mathrm{3.3.2.}jar:\mathrm{3.3.2}]atcom.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:95)[mybatis-plus-core-\mathrm{3.3.2.}jar:\mathrm{3.3.2}]atcom.sun.proxy.$Proxy159.getUserRoleCode(Unknown Source) ~[na:na]
at com.casey.service.impl.SysRoleServiceImpl.isSuperAdmin(SysRoleServiceImpl.java:29) ~[classes/:na]

排查

1. namespace 、id 和 文件名均正确
2. 配置文件对应目录正确

mybatis-plus:type-aliases-package: com.casey.domainconfiguration:log-impl: org.apache.ibatis.logging.stdout.StdOutImplmapper-locations: classpath:/mappers/*Mapper.xml

3. 编译后生成的 target 含有 xml 文件

4. maven clean 后，install
5. 重写 xml 文件
======================== 以上都没有用 ===========================
查看 git log，发现这段代码注释后就正常了。

@Bean
public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {MybatisSqlSessionFactoryBean mybatisSqlSessionFactoryBean = new MybatisSqlSessionFactoryBean();//获取mybatis-plus全局配置GlobalConfig globalConfig = GlobalConfigUtils.defaults();//mybatis-plus全局配置设置元数据对象处理器为自己实现的那个globalConfig.setMetaObjectHandler(new AutoFillHandler());mybatisSqlSessionFactoryBean.setDataSource(dataSource);//mybatisSqlSessionFactoryBean关联设置全局配置mybatisSqlSessionFactoryBean.setGlobalConfig(globalConfig);return mybatisSqlSessionFactoryBean.getObject();
}

猜测是新的 mybatisSqlSession 覆盖了配置文件的 mapper 路径。

添加以下代码

// 设置 Mapper 文件的位置
Resource[] resources = new PathMatchingResourcePatternResolver().getResources("classpath:mappers/*Mapper.xml");
mybatisSqlSessionFactoryBean.setMapperLocations(resources);

成功解决。