Ok thank you, I guess the only drawback is that I need to learn some new API :).
Alternatively I think it's not too dirty to keep the native query part restricted to getting the ids I need fetch these entities with JPA. Henno -----Oorspronkelijk bericht----- Van: Pinaki Poddar [mailto:[email protected]] Verzonden: dinsdag 10 mei 2011 10:44 Aan: [email protected] Onderwerp: Re: query that uses String REPLACE function > Criteria API. Put the three REPLACE's in a user defined function. I feel this is the cleanest. > But the first three feel much too complicated for such a simple problem. But I may be biased :) ----- Pinaki -- View this message in context: http://openjpa.208410.n2.nabble.com/query-that-uses-String-REPLACE-function-tp6344747p6347041.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
