0 Replies Latest reply on Nov 21, 2003 3:26 AM by null null

    Why this following EJBQL failed?

    null null Newbie

      I've posted this message in another forum yet, but i got no answer..After a futher week of research i can't already explain this topic.. hope someone helps this time...

      SELECT OBJECT(m) FROM Message AS m
      WHERE ( ?1 IS NULL)

      At deploytime JBoss said:

      Depends On Me: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(m) FROM Message AS
      m
      WHERE ( ?1 IS NULL)'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "IS" at line 2, column
      12.
      Was expecting one of:
      ")" ...
      "+" ...
      "-" ...
      "*" ...
      "/" ...
      "NOT" ...
      "BETWEEN" ...
      )]

      I read the EJBQL-Reference but the grammar seems to allow something like that..

      You can replace (?1 is null) with (?1 = 0) or similiar, always the same result..

      What's wrong??