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)