2 Replies Latest reply on Apr 19, 2004 6:33 PM by Kunal H. Parikh

    where contains(keywords, 'keyword list') > 0

    Kunal H. Parikh Newbie

      Hi All!

      I am attempting to use the following where clause in my SQL:

      where contains(keywords, 'keyword list') > 0
      


      I am using JBoss Dynamic-QL. However, I get the following exception:
      10:31:16,031 DEBUG [SearchTable#ejbSelectGeneric] DYNAMIC-QL: SELECT OBJECT(c) FROM SearchTable c WHERE contains(c.keywords, '?1') > 0
      10:31:16,062 INFO [STDOUT] org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "contains" at line 1, column 44.
      Was expecting one of:
       "NOT" ...
       "(" ...
       <COLLECTION_VALUED_PATH> ...
       <STRING_VALUED_PATH> ...
       "CONCAT" ...
       "SUBSTRING" ...
       "UCASE" ...
       "LCASE" ...
       <STRING_LITERAL> ...
       <STRING_VALUED_PARAMETER> ...
       <NUMERIC_VALUED_PATH> ...
       "LENGTH" ...
       "LOCATE" ...
       "ABS" ...
       "SQRT" ...
       "COUNT" ...
       "MAX" ...
       "MIN" ...
       "AVG" ...
       "SUM" ...
       <INTEGER_LITERAL> ...
       <FLOATING_POINT_LITERAL> ...
       <NUMERIC_VALUED_PARAMETER> ...
       <DATETIME_VALUED_PATH> ...
       <DATETIME_VALUED_PARAMETER> ...
       <BOOLEAN_VALUED_PATH> ...
       <BOOLEAN_VALUED_PARAMETER> ...
       "TRUE" ...
       "FALSE" ...
       <VALUE_CLASS_VALUED_PATH> ...
       <VALUE_CLASS_VALUED_PARAMETER> ...
       <ENTITY_VALUED_PATH> ...
       <IDENTIFICATION_VARIABLE> ...
       <ENTITY_VALUED_PARAMETER> ...
       "+" ...
       "-" ...
      
      10:31:16,078 INFO [STDOUT] at org.jboss.ejb.plugins.cmp.ejbql.JBossQLParser.generateParseException(JBossQLParser.java:5279)