springboot集成Mybatis-Puls踩坑记录

Mybatis-Puls报org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.sm.mapper.dao.CidDeviceDao.truncateTable

控制台错误信息

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.sm.mapper.dao.CidDeviceDao.truncateTable
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235) ~[mybatis-3.5.2.jar:3.5.2]
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.<init>(MybatisMapperMethod.java:49) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.lambda$cachedMapperMethod$0(MybatisMapperProxy.java:65) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660) ~[na:1.8.0_281]
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.cachedMapperMethod(MybatisMapperProxy.java:65) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:60) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
	at com.sun.proxy.$Proxy62.truncateTable(Unknown Source) ~[na:na]
	at com.sm.service.impl.CidDeviceServiceImpl.truncateTable(CidDeviceServiceImpl.java:22) ~[classes/:na]
	at com.sm.service.impl.CidDeviceServiceImpl$$FastClassBySpringCGLIB$$27d7f80f.invoke(<generated>) ~[classes/:na]
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.6.RELEASE.jar:5.1.6.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684) ~[spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]
	at com.sm.service.impl.CidDeviceServiceImpl$$EnhancerBySpringCGLIB$$eddd28ad.truncateTable(<generated>) ~[classes/:na]
	at com.sm.quartz.ADSTQuartzTask.truncateTable(ADSTQuartzTask.java:170) ~[classes/:na]
	at com.sm.quartz.ADSTQuartzTask.apiSer(ADSTQuartzTask.java:62) ~[classes/:na]
	at com.sm.quartz.ADSTQuartzTask.executeInternal(ADSTQuartzTask.java:34) ~[classes/:na]
	at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:75) ~[spring-context-support-5.1.6.RELEASE.jar:5.1.6.RELEASE]
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.1.jar:na]
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.1.jar:na]

错误配置

########################## mybatis-plus ###############################
mybatis-plus.mapper-locations=classpath:com/sm/mapper/*Mapper.xml   # 扫描mapperxml文件
mybatis-plus.type-aliases-package=com.sm.entity     # 扫描实体

正确配置

注意配置书写格式，注释和具体配置换行隔开

########################## mybatis-plus ###############################
# 扫描mapperxml文件
mybatis-plus.mapper-locations=classpath:com/sm/mapper/*Mapper.xml
# 扫描实体
mybatis-plus.type-aliases-package=com.sm.entity