Hallo all,
I try to find some entities through query method case insensitivitely, in general sql I'd use pair of UPPER functions but in EJB-QL I should use ucase function, as I understood.
standardjbosscmp-jdbc.xml have function mapping like:
<function-mapping>
<function-name>ucase</function-name>
<function-sql>upper(?1)</function-sql>
</function-mapping>
But when I try to use it in <ejb-ql><![CDATA[SELECT OBJECT(o) FROM AgendaInstanceEJB o WHERE o.roomId = UCASE(?1)]]></ejb-ql> I get exception in deploy time:
...ParseException: Encountered "UCASE" at line 1, column 60.
Was expecting one of:
"CONCAT" ...
"SUBSTRING" ...
"(" ...
<STRING_LITERAL> ...
<STRING_VALUED_PARAMETER> ...
<STRING_VALUED_PATH> ...
))
please, geve me a piece of good advice how use it in right way.
P.S. I use jboss vestion 3.0.4
regards.