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 <ashish.kulkarni13@gmail.com> 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 <clinton.begin@gmail.com> wrote:
> >
> > Use a CDATA section, or < > 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
> > >
> >
> >
>
|