The locate() SQL function doesn't work on SAP HANA because JPQL specifies it as locate (<needle>, <haystack>) whereas HANA specifies it as locate(<haystack>, <needle>).