Hi, I try to build a not case-sensitive Finder but it doesn't work this way:
<query-method>
<method-name>findByKennung</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<jboss-ql>
<![CDATA[
SELECT OBJECT(b) FROM BenutzerBean b
WHERE UCASE(b.implKennung) = UCASE(?1)
]]>
</jboss-ql>
I also tried
<jboss-ql>
<![CDATA[
SELECT OBJECT(b) FROM BenutzerBean b
WHERE UCASE(b.implKennung) LIKE UCASE(?1)
]]>
</jboss-ql>
I would like to be able to find 'test' and 'Texas' with 't%' but I do find this way only 'test' ;-(
Ooops, my mistake! It works! Sorry