Hi. I have used following EQL:
SELECT OBJECT(o) FROM Orders AS o WHERE o.date BETWEEN ?1 AND ?2
and this is what i've got at deploy:
2004-04-07 16:23:46,038 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.OrderEJB#findByDate] EJB-QL: SELECT OBJECT(o) FROM Orders AS o WHERE o.date BETWEEN ?1 AND ?2
2004-04-07 16:23:46,098 INFO [STDOUT] org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "BETWEEN" at line 1, column 48.
Was expecting one of:
">" ...
"<" ...
"=" ...
"<>" ...
It's not a problem to rewrite aformentioned code due to parsers demands, but simply interesting what is wrong with current version. Any ideas ?
Thank you, Bogdan