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, 19 Mar 2007 14:58:32 GMT
Hi
I have posted another thread with detail explaination
this is the thread
http://www.nabble.com/forum/ViewPost.jtp?post=9499524&framed=y

if you can take a look and tell me if you have any solution for it

Ashish

On 3/18/07, j-lists <jamisonlists@gmail.com> wrote:
>
> I would guess that this is a database encoding problem, have you
> confirmed that the ">"s are causing a problem or just the non-ascii
> characters? If the driver is getting generating invalid UTF16 for Java
> (internally) that might be causing the failure... unfortunately this
> is a real pain to debug and fix. Bulk loaders can fill varchars with
> badly encoded text that give trouble.
>
> Just a theory.
> -J
>
> On 3/12/07, Yuvraj Shinde <Yuvraj.Shinde@sos.sungard.com> wrote:
> >
> >
> >
> >
> > You can use CDATA tag.
> >
> >
> >
> >  ________________________________
> >
> >
> > From: Ashish Kulkarni [mailto:ashish.kulkarni13@gmail.com]
> >  Sent: Monday, March 12, 2007 5:47 AM
> >  To: user-java@ibatis.apache.org
> >  Subject: ibatis, XML and special characters
> >
> >
> >
> >
> > 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