can IBATIS handle mysql "DATE" keyword?
|
View:
New views
8 Messages
—
Rating Filter:
Alert me
|
 |
can IBATIS handle mysql "DATE" keyword?
by jrhitokiri
::
Rate this Message:
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 |
|
|
RE: can IBATIS handle mysql "DATE" keyword?
by Niels Beekman-2
::
Rate this Message:
You should escape your < and >.
Niels -----Original Message----- From: jrhitokiri [mailto:jrhitokiri@...] Sent: Wednesday, October 14, 2009 10:21 AM To: user-java@... 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: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@... --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@... |
|
|
Re: can IBATIS handle mysql "DATE" keyword?
by Ed Stafford-3
::
Rate this Message:
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@...> You should escape your < and >. |
|
|
Re: can IBATIS handle mysql "DATE" keyword?
by jrhitokiri
::
Rate this Message:
will this be okay:
CODE: <select id="getPossibleConflicts" parameterClass="iReserveClasses.Reservations" resultClass="iReserveClasses.Reservations"> <![CDATA[ select * from reservations where ((DATE(start) < DATE(#start#)) AND (DATE(#start#) < DATE(end))) OR ((DATE(start) < DATE(#end#)) AND (DATE(#end#) < DATE(end))) ]]> </select> Regards, JR
|
|
|
RE: can IBATIS handle mysql "DATE" keyword?
by Niels Beekman-2
::
Rate this Message:
Did you try it? Looks like it should work.
-----Original Message----- From: jrhitokiri [mailto:jrhitokiri@...] Sent: Wednesday, October 14, 2009 12:11 PM To: user-java@... Subject: Re: can IBATIS handle mysql "DATE" keyword? will this be okay: CODE: <select id="getPossibleConflicts" parameterClass="iReserveClasses.Reservations" resultClass="iReserveClasses.Reservations"> <![CDATA[ select * from reservations where ((DATE(start) < DATE(#start#)) AND (DATE(#start#) < DATE(end))) OR ((DATE(start) < DATE(#end#)) AND (DATE(#end#) < DATE(end))) ]]> </select> Regards, JR Ed Stafford-3 wrote: > > 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@...> > > -- View this message in context: http://www.nabble.com/can-IBATIS-handle-mysql-%22DATE%22-keyword--tp2588 7145p25888427.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@... --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@... |
|
|
RE: can IBATIS handle mysql "DATE" keyword?
by jrhitokiri
::
Rate this Message:
I tried it. It works now. Wow, and I was stumped on that for an hour before I decided to post here. this helped a lot! Thanks!
But anyway, aside from the greater than and less than symbols, what other symbols need escaping? so that I'll know when to use this again.
|
|
|
RE: can IBATIS handle mysql "DATE" keyword?
by meindert-3
::
Rate this Message:
Off the top of my head that would be <, # and $
-----Original Message----- From: jrhitokiri [mailto:jrhitokiri@...] Sent: 14 October 2009 01:02 PM To: user-java@... Subject: RE: can IBATIS handle mysql "DATE" keyword? I tried it. It works now. Wow, and I was stumped on that for an hour before I decided to post here. this helped a lot! Thanks! But anyway, aside from the greater than and less than symbols, what other symbols need escaping? so that I'll know when to use this again. Niels Beekman-2 wrote: > > Did you try it? Looks like it should work. > > -----Original Message----- > From: jrhitokiri [mailto:jrhitokiri@...] > Sent: Wednesday, October 14, 2009 12:11 PM > To: user-java@... > Subject: Re: can IBATIS handle mysql "DATE" keyword? > > > will this be okay: > > > CODE: > <select id="getPossibleConflicts" > parameterClass="iReserveClasses.Reservations" > resultClass="iReserveClasses.Reservations"> > <![CDATA[ > > select * from reservations where ((DATE(start) < DATE(#start#)) > AND > (DATE(#start#) < DATE(end))) OR ((DATE(start) < DATE(#end#)) AND > (DATE(#end#) < DATE(end))) > ]]> > > </select> > > > Regards, > JR > > > Ed Stafford-3 wrote: >> >> 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@...> >> >> > > -- > View this message in context: > http://www.nabble.com/can-IBATIS-handle-mysql-%22DATE%22-keyword--tp2588 > 7145p25888427.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscribe@... > For additional commands, e-mail: user-java-help@... > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscribe@... > For additional commands, e-mail: user-java-help@... > > > -- View this message in context: http://www.nabble.com/can-IBATIS-handle-mysql-%22DATE%22-keyword--tp25887145 p25888996.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@... No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.15/2434 - Release Date: 10/13/09 19:11:00 --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@... For additional commands, e-mail: user-java-help@... |
|
|
Re: can IBATIS handle mysql "DATE" keyword?
by Ed Stafford-3
::
Rate this Message:
The required escape characters for xml are:
" " ' ' < < > > & & Your problem isn't so much with iBatis xml config as it is with the general requirements of well formed xml. Cheers, -Ed 2009/10/14 meindert <meindert@...> Off the top of my head that would be <, # and $ |
| Free embeddable forum powered by Nabble | Forum Help |
