0 Replies Latest reply on Sep 11, 2003 12:21 PM by dandesch

    EJBQL with > and <

    dandesch

      Hello, I'm attempting to run version 3.2.1, but on startup I get this error:

      org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT object (a) FROM Account a WHERE a.accountNumber > ?1 AND a.accountNumber < ?2
      AND a.company.companyId = ?3'; - nested throwable: (org.jboss.ejb.plugins.cmp.e
      jbql.ParseException: Encountered ">" at line 1, column 56.
      Was expecting one of:
      "=" ...
      "<>" ...
      )

      Now, it is not inconceivable that there is something wrong with the syntax of my query, but why is JBoss expecting only these characters: "=" or "<>" (equal or not equal)?