You could also wrap it in CDATA block if you don't want to deal with escaping everything (http://www.w3schools.com/xmL/xml_cdata.asp).
-Ed 2009/10/14 Niels Beekman <n.beek...@wis.nl> > You should escape your < and >. > > Niels > > -----Original Message----- > From: jrhitokiri [mailto:jrhitok...@gmail.com] > Sent: Wednesday, October 14, 2009 10:21 AM > To: user-java@ibatis.apache.org > Subject: can IBATIS handle mysql "DATE" keyword? > > > I have this query I tested in mysql. it works when I type it and use > example > input: > > CODE: > select * from eservations where > (DATE(start) < DATE(input_start) AND > DATE(input_start) < DATE(END)) > > OR > > (DATE(start) < DATE(input_end) AND > DATE(input_end) < DATE(end)) > > the thing is, ibatis throws an exception when I add it to my xml file: > > CODE: > <select id="getPossibleConflicts" > parameterClass="iReserveClasses.Reservations" > resultClass="iReserveClasses.Reservations"> > select * from reservations where ((DATE(start) < DATE(#start#)) > AND > (DATE(#start#) < DATE(end))) OR ((DATE(start) < DATE(#end#)) AND > (DATE(#end#) < DATE(end))) > </select> > > Now I know it's this particular query that does not work, because when I > take it out, no exceptions are thrown. Is there something wrong with > this > query? Or can Ibatis use the "Date" keyword? > > ERROR SNAPSHOT: > java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. > Cause: com.ibatis.common.xml.NodeletException: Error parsing XML. > Cause: > org.xml.sax.SAXParseException: The content of elements must consist of > well-formed character data or markup. > at > com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:12 > 3) > ... > > Please, I need your help with this. Thanks. > > kind regards > JR > -- > View this message in context: > http://www.nabble.com/can-IBATIS-handle-mysql-%22DATE%22-keyword--tp2588 > 7145p25887145.html<http://www.nabble.com/can-IBATIS-handle-mysql-%22DATE%22-keyword--tp2588%0A7145p25887145.html> > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > >
