Hi
The problem is with the data coming from database, in database they have special characters, so when ibatis runs the SQL statement and converts it to XML it does not work because of these characters in the data

Ashish

On 3/11/07, Clinton Begin <clinton.begin@gmail.com> wrote:
Use a CDATA section, or &lt; &gt; etc...

It's just XML.  ;-)


On 3/11/07, Ashish Kulkarni < ashish.kulkarni13@gmail.com> wrote:
Hi
I am using ibatis to run a SQL statement which returns a XML as output as shown below,

<select id="getItemSpeicalNotes" resultClass="xml" parameterClass="java.math.BigDecimal" xmlResultName="ITEMSPECIALNOTES">
        SELECT P706DETL as SPECIALNOTE , PDLINE as PDLINENOTES FROM PU1706, PU1013 WHERE P706ORD = PDPORD and PDSPEC = P706SPEC and PDPORD = #value# order by P706LINE
    </select>


I am having issues when the data returned by SQL statement has special characters like > or umlots ,
how do i handle this, is there a way to tell ibatis to parse these special characters and make it XML complaint before creating XML result

Ashish