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 <[EMAIL PROTECTED]> 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 < [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 >
