1 Reply Latest reply on Dec 19, 2002 10:05 AM by Vanessa

    QL Finder not case-sensitive?

    Vanessa Newbie

      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' ;-(