0 Replies Latest reply on Oct 24, 2003 2:26 PM by Jeff Edwards

    Use of Functions in WHERE clause

    Jeff Edwards Newbie

      I've defined something like this for my finder:

      SELECT OBJECT(a) FROM mySchema AS a WHERE LOCATE(UCASE(?1),UCASE(a.myVariable)

      Deployment of my CMP EJB results in the following error:

      Caused by: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "UCASE" at line 1, column 59.
      Was expecting one of:
      "CONCAT" ...
      "SUBSTRING" ...
      "(" ...
      <STRING_LITERAL> ...
      <STRING_VALUED_PARAMETER> ...
      <STRING_VALUED_PATH> ...

      Can someone please inform me on the appropriate use of JBOSS specific queries (such as lcase and ucase)?

      Thanks,

      Jeff