You should escape your < and >. Niels
-----Original Message----- From: jrhitokiri [mailto:[email protected]] Sent: Wednesday, October 14, 2009 10:21 AM To: [email protected] 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 Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
