Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: domain of jamisonlists@gmail.com
 designates 64.233.182.189 as permitted sender)
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:content-transfer-encoding:content-disposition:references;
        b=Pq1KtFhYUw3iNQ6BYmMYkbg2cB1hFu69fDMphkD1cLpqltAvERUK5DgWfOWdb6gpW/39cblBzDASLwwPaKgEqdVyLql7IPl27O0HnBFHAIVjtyONmGyxEoKHZ6CvKmykjf1/Me6vUO6hw0DeYFPWuunv1FTKt60m/IFUC7CEgzo=
Message-ID: <71d231c70703180605w4113d3d6mf1c21895d148dbb8@mail.gmail.com>
Date: Sun, 18 Mar 2007 21:05:41 +0800
From: j-lists <jamisonlists@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: ibatis, XML and special characters
In-Reply-To: 
 <5EBE57594E74E84DB1DC6BA8E279389D023144B9@SOS-MAILSRV.ascindia.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <878c6f8e0703111716n1bab2704x4fca455310d30420@mail.gmail.com>
	 <5EBE57594E74E84DB1DC6BA8E279389D023144B9@SOS-MAILSRV.ascindia.com>

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 a=
s
> shown below,
>
>  <select id=3D"getItemSpeicalNotes" resultClass=3D"xml"
> parameterClass=3D"java.math.BigDecimal"
> xmlResultName=3D"ITEMSPECIALNOTES">
>          SELECT P706DETL as SPECIALNOTE , PDLINE as PDLINENOTES FROM PU17=
06,
> PU1013 WHERE P706ORD =3D PDPORD and PDSPEC =3D P706SPEC and PDPORD =3D #v=
alue#
> order by P706LINE
>      </select>
>
>
>  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 speci=
al
> characters and make it XML complaint before creating XML result
>
>  Ashish