ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Kulkarni" <ashish.kulkarn...@gmail.com>
Subject Re: ibatis, XML and special characters
Date Mon, 12 Mar 2007 01:14:29 GMT
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
> >
>
>

Mime
View raw message