天天看点

mybatis抛异常Could not find SQL statement to include with refid ‘xxx‘异常信息

项目启动mybatis抛异常Could not find SQL statement to include with refid 'xxx'

  • 异常信息
    • 排查
    • 原因

异常信息

Invocation of init method failed; 
nested exception is org.apache.ibatis.builder.IncompleteElementException: 
Could not find SQL statement to include with refid 'com.xxx.statistic.reports.mapper.WebsiteBaseDataMapper.companyRecruitStatisticBaseSql'

Caused by: java.lang.IllegalArgumentException: 
XML fragments parsed from previous mappers does not contain value for 
com.job168.zhnf_core.statistic.reports.mapper.WebsiteBaseDataMapper.companyRecruitStatisticBaseSql 
at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:933)
at org.apache.ibatis.builder.xml.XMLIncludeTransformer.findSqlFragment(XMLIncludeTransformer.java:96)
	
           

错误信息大概意思:mybatis解析xml时,没有找到名称为 companyRecruitStatisticBaseSql的sql片段。

排查

尝试用companyRecruitStatisticBaseSql在xml文件中搜索, 发现是存在的…

原因

其实是个低级错误,我把sql标签写成了select标签