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)
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830848#3830848
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3830848
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
