9 Replies Latest reply on Oct 9, 2002 1:39 PM by Alexey Loubyansky

    JBoss 3.0.3/EJBQL - comparing dates

    Noel Rocher Apprentice

      Hi all,


      here is my EJBQL query :

      <ejb-ql>
      <![CDATA[select object(a) FROM Country AS c
        WHERE
          c.row_valid_to_date IS NOT NULL AND
      (c.row_valid_to_date < ?1 OR
      c.row_valid_to_date = ?1) ]]>
      </ejb-ql>



      Here is the message I have :

      org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "1" at line 2, column 112.
      Was expecting:
      <STRING_LITERAL> ...
      )


      What is wrong ?
      Thanks