Ohhhh.....sorry. That's kind of crazy because iBATIS just uses the DOM libraries to create the XML. I wonder why it wouldn't encode special characters properly?
Clinton On 3/11/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
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 <[EMAIL PROTECTED]> wrote: > > Use a CDATA section, or < > etc... > > It's just XML. ;-) > > On 3/11/07, Ashish Kulkarni < [EMAIL PROTECTED]> 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 > > > >
