ibatis的isEqual上不能有CDATA吗，小弟我这样做老是报错，求高手看看是咋回事呀-Oracle教程-爱易网页

ibatis的isEqual上不能有CDATA吗，小弟我这样做老是报错，求高手看看是咋回事呀

日期：2014-05-16　浏览次数：21052 次

ibatis的isEqual下不能有CDATA吗，我这样做老是报错，求高手看看是怎么回事呀
sql语句配置：

XML code


<select id="queryJobProjiectCondition" remapResults="true" parameterClass="java.util.HashMap" resultClass="bean.JobProjiect">
        select * from IPWF_LOCAL_JOB_PROJECT where 1=1
        <isNotNull prepend="and" property="queryJobNumber">
            JOB_NUMBER like '%'||#queryJobNumber#||'%'
        </isNotNull>
        <isNotNull prepend="and" property="queryJobContent">
            JOB_CONTENT like '%'||#queryJobContent#||'%'
        </isNotNull>
        <isNotNull prepend="and" property="queryJobExecutorName">
            JOB_EXECUTOR_NAME like '%'||#queryJobExecutorName#||'%'
        </isNotNull>
        <isNotEmpty prepend="and" property="queryJobCycle">
            JOB_CYCLE = #queryJobCycle#
        </isNotEmpty>
        <isNotEmpty prepend="and" property="queryJobMode">
            JOB_MODE = #queryJobMode#
        </isNotEmpty>
        <isEqual prepend="and" property="queryPeriodOfValidity" compareValue="yes">
            <![CDATA[
                JOB_STATRTIME <= sysdate and JOB_ENDTIME >= sysdate or JOB_ENDTIME = null 
            ]]>
        < /isEqual>
        <isEqual prepend="and" property="queryPeriodOfValidity" compareValue="no">
            <![CDATA[
                JOB_ENDTIME <= sysdate or JOB_ENDTIME = null 
            ]]>
        < /isEqual>
        ORDER  BY S_SEQ_ID DESC
    </select>

出错的代码应该是在下面这段代码中，求高手给我看看是怎么回事

XML code


<isEqual prepend="and" property="queryPeriodOfValidity" compareValue="yes">
            <![CDATA[
                JOB_STATRTIME <= sysdate and JOB_ENDTIME >= sysdate or JOB_ENDTIME = null 
            ]]>
        < /isEqual>
        <isEqual prepend="and" property="queryPeriodOfValidity" compareValue="no">
            <![CDATA[
                JOB_ENDTIME <= sysdate or JOB_ENDTIME = null 
            ]]>
        < /isEqual>

报错显示为：

Java code


java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.


Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.


Caused by: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.


Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.

Caused by: org.xml.sax.SAXParseException: The content of elements mus

免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。

ibatis的isEqual上不能有CDATA吗，小弟我这样做老是报错，求高手看看是咋回事呀

相关资料更多>

推荐阅读更多>