Does latest version of Hibernate support pagination with Projection select query ?
Current we are pulling all records and applying pagination
I personally don’t know which limitations you are talking about, but it seems you’re talking about Hibernate ORM projections, so I’m moving this out of the “Hibernate Search” category. Hibernate Search is a different project dealing with out-of-database, full-text indexing. You’ll get more answers in the “Hibernate ORM” category.
@rtalapaneni You should add a code example and the executed SQL statements so that we can get a better understanding of what you are doing.