ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ed Stafford <walter.staff...@carbonsixty.co.uk>
Subject Re: can IBATIS handle mysql "DATE" keyword?
Date Wed, 14 Oct 2009 09:30:56 GMT
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.beekman@wis.nl>

> You should escape your < and >.
>
> Niels
>
> -----Original Message-----
> From: jrhitokiri [mailto:jrhitokiri@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-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message