In JBoss 4.0.0, I am trying to deploy an entity EJB with the following EJBQL statement in it
SELECT OBJECT(f) FROM address f WHERE f.validDate <= ?1 During deployment I get a ParseException on "<=" operator. According to the EJB 2.0 spec, <= is a valid operator. validDate field is a DATE field in the database. On changing the statement as follows, I was able to make it work. SELECT OBJECT(f) FROM address f WHERE f.validDate < ?1 or f.validDate = ?1 I am interested in knowing why the first form of SELECT statement did not work. Thanks, Ancin View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3853956#3853956 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3853956 ------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user