3 Replies Latest reply on Aug 6, 2002 1:36 PM by Dain Sundstrom

    EJBQL Parser Exception: Clausule "BETWEEN"

    José Luis Newbie

      Hello all:

      I'm working with JBoss 3.0 and I'm trying to do something with CMP.

      I receive this exception:

      org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "BETWEEN" at line 1, column 107.
      Was expecting one of:
      ">" ...

      The query is:
      SELECT OBJECT(a) FROM HG_cmeb_EventMonInfo AS a WHERE a.instId = ?1 AND a.instServer = ?2 AND a.timeStamp BETWEEN ?3 AND ?4

      Is it that JBoss does not suppoprt BETWEEN clausule?? (EJB 2.0 Spec supports it !!)

      The courious thing is that JAWS seems to support it.
      But now I'm using JBoss3.0's jbosscmp-jdbc it doesn't work.

      Any idea about this exception ?

      Thanks a lot.