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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > > > > You can use CDATA tag. > > > > ________________________________ > > > From: Ashish Kulkarni [mailto:[EMAIL PROTECTED] > 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