Mybatis xml 에러. The content of elements must consist of well-formed character data or markup. [MarkupNotRecognizedInContent]

 

 

<select id="list" parameterType="kr.or.ddit.vo.LprodVO" resultType="kr.or.ddit.vo.LprodVO">
    select * from 
            (select ROW_NUMBER() over(order by lprod_id) rn, l.*
                from lprod l)
        where rn>=1 and rn <=5
</select>

 

페이징 처리하려고 했는뎅...

 

 

 

 

The content of elements must consist of well-formed charater data or markup. 라는 에러가 떴당!!

 

 

내용에 부등호가 있을때 발생하는 에러 !!

<![CDATA[]]> 으로 감싸주면 된당!!  🤩

 

<select id="list" parameterType="kr.or.ddit.vo.LprodVO" resultType="kr.or.ddit.vo.LprodVO">
    <![CDATA[
        select * from 
            (select ROW_NUMBER() over(order by lprod_id) rn, l.*
                from lprod l)
        where rn>=1 and rn <=5
    ]]>
</select>