0 Replies Latest reply on Apr 7, 2004 8:53 AM by Bogdan

    Jboss 4: BETWEEN in EQL

    Bogdan Newbie

      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