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:123)
...
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--tp25887145p25887145.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]
