Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 59200 invoked from network); 20 Mar 2007 15:01:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 20 Mar 2007 15:01:21 -0000 Received: (qmail 52660 invoked by uid 500); 20 Mar 2007 15:01:25 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 52650 invoked by uid 500); 20 Mar 2007 15:01:25 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 52632 invoked by uid 99); 20 Mar 2007 15:01:25 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Mar 2007 08:01:25 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of ashish.kulkarni13@gmail.com designates 64.233.182.184 as permitted sender) Received: from [64.233.182.184] (HELO nf-out-0910.google.com) (64.233.182.184) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Mar 2007 08:01:14 -0700 Received: by nf-out-0910.google.com with SMTP id l24so374704nfc for ; Tue, 20 Mar 2007 08:00:52 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=hcc58gXtdi1HYy45+wN4FDeGSuG9TOYJWxrDBDNPCA+mf8r8n15cfGEjy2u1T2HaEJODm8IISxWpHexIGmKRiQBdKcmLxuIgHFeztDee1g6Nes6n04mVVSlJSVhGQGARnlDy0rRuujLzRoGZwGcSGHU/0AEvh7b/aDe6gHT7ML4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=MuyD7jdKlWQbqgsTI6bzH720/1MlhK1Up3ITePFOTeEXb5lqDUhyYHn5ydZ8NRv/tTEYplxNV9wX1YEpbzAL/D0ZtQLYFeR79t9iqWBFHSmekBVGUfpcFWR03QHunyUEQO6Bxh1BQz3cfvPS5r8wyciSTKTAb69o9yns/81QjRQ= Received: by 10.82.163.13 with SMTP id l13mr12844526bue.1174402850161; Tue, 20 Mar 2007 08:00:50 -0700 (PDT) Received: by 10.82.181.5 with HTTP; Tue, 20 Mar 2007 08:00:50 -0700 (PDT) Message-ID: <878c6f8e0703200800m8e3fe94n3ad4fcb5000c8dc0@mail.gmail.com> Date: Tue, 20 Mar 2007 11:00:50 -0400 From: "Ashish Kulkarni" To: user-java@ibatis.apache.org, clinton.begin@gmail.com Subject: Re: ibatis, XML and special characters In-Reply-To: <16178eb10703190907j3bad8cfet83db34e54368e9a4@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_114259_29066310.1174402850034" References: <878c6f8e0703111716n1bab2704x4fca455310d30420@mail.gmail.com> <5EBE57594E74E84DB1DC6BA8E279389D023144B9@SOS-MAILSRV.ascindia.com> <71d231c70703180605w4113d3d6mf1c21895d148dbb8@mail.gmail.com> <878c6f8e0703190758j626df592x1bcbcdc1d6ab46ee@mail.gmail.com> <16178eb10703190907j3bad8cfet83db34e54368e9a4@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_114259_29066310.1174402850034 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi It is a German Language character umlaut here is more information about it http://en.wikipedia.org/wiki/Germanic_umlaut I try to change the database driver encoding, i am using DB2 on As400 as database, and see if it works. But the feature in ibatis to change encoding on DOM builder will be great, specially if you dealing with non - english database. Ashish On 3/19/07, Clinton Begin wrote: > > Yeah, that's definitely a character encoding mismatch. You can either se= t > your database driver to a different encoding (check your docs), or we cou= ld > 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 wrote: > > > > Hi > > I have posted another thread with detail explaination > > this is the thread > > http://www.nabble.com/forum/ViewPost.jtp?post=3D9499524&framed=3Dy > > > > 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 Jav= a > > > (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, > > > > > > > > > > > > > > > > > > > > I am having issues when the data returned by SQL statement has > > > special > > > > characters like > or umlots =FC, > > > > 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 > > > > > > > > ------=_Part_114259_29066310.1174402850034 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi
It is a German Language character umlaut
here is more information = about it
http:/= /en.wikipedia.org/wiki/Germanic_umlaut

I try to change the datab= ase driver encoding, i am using DB2 on As400 as database, and see if it wor= ks.

But the feature in ibatis to change encoding on DOM builder will be= great, specially if you dealing with non - english database.

Ashish=

On 3/19/07, Clinton Begin <clinton.be= gin@gmail.com> wrote:
Yeah, that's definitely a character encoding mismatch.  You can ei= ther 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 c= ausing the problem. =20

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

Clinton 




On 3/19/07,=20 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=3D9499524&framed=3Dy

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 p= roblem, 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 withbadly encoded text that give trouble.

Just a theory.
-J

O= n 3/12/07, Yuvraj Shinde < Yuvraj.Shinde@sos.sungard.com> wrote:
>
>
>
>= ;
> You can use CDATA tag.
>
>
>
>  = ;________________________________
>
>
> From: Ashish Kulk= arni [mailto: ashish.kulkarni13@gmail.com<= /a>]
>  Sent: Monday, March 12, 2007 5:47 AM
> &= nbsp;To: user-java@ibatis.apache.org
>  Subject: ibatis, XML and= special characters
>
>
>
>
> Hi
>  I am using i= batis to run a SQL statement which returns a XML as output as
> shown= below,
>
>  <select id=3D"getItemSpeicalNote= s" resultClass=3D"xml"
> parameterClass=3D"java.math.BigDecimal"
> xmlResul= tName=3D"ITEMSPECIALNOTES">
>    &nb= sp;     SELECT P706DETL as SPECIALNOTE , PDLINE as= PDLINENOTES FROM PU1706,
> PU1013 WHERE P706ORD =3D PDPORD and PDSPE= C =3D P706SPEC and PDPORD =3D #value#
> order by P706LINE
>      </= select>
>
>
>  I am having issues when the d= ata returned by SQL statement has special
> characters like > or u= mlots =FC,
>  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



------=_Part_114259_29066310.1174402850034--