Hello! I do not know if this is the correct forum..
I use Hibernate with H2 and JPA. If I create a JPA Query and use the Methods setFirstResult() and setMaxResults() this will not mirrored in the query as LIMIT and OFFSET as I would expect. And the query (with LEFT JOIN FETCH) is very slow in this case. If I do not use FETCH it is fast and if I have a criteria that reduce the resultset it is fast, too. Is it possible to reflect the methods in LIMIT and OFFSET at SQL query level? best regards, marque --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
