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, 19 Mar 2007 16:07:01 GMT
Yeah, that's definitely a character encoding mismatch.  You can either set
your database driver to a different encoding (check your docs), or we could
possibly introduce a feature in iBATIS that will let you set the encoding on
the DOM builder so that it understands whichever character is causing the
problem.

Which character is it though?  It almost looks like it was complaining about
-- (double dashes), which are reserved for closing comments IIRC.

Clinton



On 3/19/07, Ashish Kulkarni <ashish.kulkarni13@gmail.com> wrote:
>
> 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