ibatis, XML and special characters

2007-03-11 Thread Ashish Kulkarni
Hi I am using ibatis to run a SQL statement which returns a XML as output as shown below, SELECT P706DETL as SPECIALNOTE , PDLINE as PDLINENOTES FROM PU1706, PU1013 WHERE P706ORD = PDPORD and PDSPEC = P706SPEC and PDPORD = #value# order by P706LINE I am having issues when the data r

Re: ibatis, XML and special characters

2007-03-11 Thread Clinton Begin
Use a CDATA section, or < > etc... It's just XML. ;-) On 3/11/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: Hi I am using ibatis to run a SQL statement which returns a XML as output as shown below, SELECT P706DETL as SPECIALNOTE , PDLINE as PDLINENOTES FROM PU1706, PU1013 WHERE P70

Re: ibatis, XML and special characters

2007-03-11 Thread Ashish Kulkarni
Hi The problem is with the data coming from database, in database they have special characters, so when ibatis runs the SQL statement and converts it to XML it does not work because of these characters in the data Ashish On 3/11/07, Clinton Begin <[EMAIL PROTECTED]> wrote: Use a CDATA section,

Re: ibatis, XML and special characters

2007-03-11 Thread Clinton Begin
O.sorry. That's kind of crazy because iBATIS just uses the DOM libraries to create the XML. I wonder why it wouldn't encode special characters properly? Clinton On 3/11/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: Hi The problem is with the data coming from database, in database th

RE: ibatis, XML and special characters

2007-03-11 Thread Yuvraj Shinde
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 outpu

Lazy loading issues

2007-03-11 Thread Wouter Roose
Hello Concerning http://opensource.atlassian.com/confluence/oss/display/IBATIS/Lazy+loading+i ssues I encountered the second problem. Could somebody be so kind to add some coding examples to the solution