Could not find value method on SQL annotation.Cause: org.xml.sax.SAXParseException;

最新推荐文章于 2021-10-27 16:16:34 发布

又是喝白开水

最新推荐文章于 2021-10-27 16:16:34 发布

阅读量1.1k

点赞数

分类专栏： mybatis

本文链接：https://blog.csdn.net/qq_37599827/article/details/100044162

版权

mybatis 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

报错内容：
org.apache.ibatis.builder.BuilderException: Could not find value method on SQL annotation. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: org.xml.sax.SAXParseException; The content of elements must consist of well-formed character data or markup.

报错语句：

SELECT  DISTINCT patients.p_sid,checkinfo.c_jh_flag,checkinfo.c_sample_hg,checkinfo.c_card_no,
wcjgs = (select count(*) from checkinfo c where c.c_sid = checkinfo.c_sid and isnull(c.c_flag,0) = 0)
FROM  patients inner join checkinfo on 
patients.p_id = checkinfo.c_p_id and 
isnull(checkinfo.c_sample_type,0) = 1 and 
isnull(checkinfo.c_type,0) = 1 and 
isnull(patients.p_type,1) = 1 
and checkinfo.c_sid not in (select dj_min_sid from sampledjmx where dj_xm_sum = -1)  
and checkinfo.c_sid not in (select s_sy_sid from bhgbbdj where isnull(s_sy_sid,'') <> '');

解决方法：
详细解答请查看