SAP JPA - case-insensitive search

[Former Member]

Hi there, is it possible to have a case-insensitive search with SAP JPA? The keywords UPPER, LOWER aren't available in the query (OpenSQL limitation I guess).

The only way I see is to create a duplicates columns for the search relative atributes and make the data upper or lower case before save. May be there is another options? More suitable and elegant?

[rolf_paulsen · Accepted solution]

Hi,

you may bypass openSQL by native queries.

Make sure that you use the hint described in

http://help.sap.com/saphelp_nwce72/helpdata/en/4a/0cf02870c540caab611d56220ec0cb/frameset.htm

together with createNativeQuery.

But anyway, the approach with duplicates columns enables you to create indexes on these UPPER columns. It is not too bad.

Regards,

Rolf

[Former Member · Accepted solution]

Thank you!

That helps even without native query.

BTW, I can create indices and on the original columns.