mybatis를 사용하면서 xml에 sql문을 입력하게 되는데 하기와 같은 에러가 발생

쿼리문 : DELETE
        FROM    CAMPAIGN_CUSTOMER_INFO
        WHERE   REG_ID = #{userId}
            AND CAMPAIGN_ID = 0
            AND GROUP_SEQUENCE < #{groupSequence}

에러 내용 : The content of elements must consist of well-formed character data or markup.

해결방안 :

<delete id="deleteCampaignCustomerGr" parameterType="map">
<![CDATA[
DELETE
        FROM    CAMPAIGN_CUSTOMER_INFO
        WHERE   REG_ID = #{userId}
            AND CAMPAIGN_ID = 0
            AND GROUP_SEQUENCE < #{groupSequence}
]]>
</delete>

+ Recent posts

mybatis를 사용하면서 xml에 sql문을 입력하게 되는데 하기와 같은 에러가 발생

쿼리문 : DELETE
        FROM    CAMPAIGN_CUSTOMER_INFO
        WHERE   REG_ID = #{userId}
            AND CAMPAIGN_ID = 0
            AND GROUP_SEQUENCE < #{groupSequence}

에러 내용 : The content of elements must consist of well-formed character data or markup.

해결방안 :

<delete id="deleteCampaignCustomerGr" parameterType="map">
<![CDATA[
DELETE
        FROM    CAMPAIGN_CUSTOMER_INFO
        WHERE   REG_ID = #{userId}
            AND CAMPAIGN_ID = 0
            AND GROUP_SEQUENCE < #{groupSequence}
]]>
</delete>

+ Recent posts