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