ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Clinton Begin" <clinton.be...@gmail.com>
Subject Re: ibatis, XML and special characters
Date Mon, 12 Mar 2007 01:31:58 GMT
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 &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