Sorting and pagination with Hibernate Criteria – How it can go wrong with joins
Posted by Jeroen van Wilgenburg mid-morning: December 11th, 2008
Lately I ran into an annoying problem with Hibernate. I tried to do pagination on a query result which was doing an SQL-JOIN under the hood. The query before paging returned about 100 results. When I turned on paging (with 20 results per page) all the pages had less than 20 results!
The reason for this is that with a JOIN there can be duplicate results and those results are filtered out after pagination is done. In this blog I will explain how to solve those problems and it also a cleaner way to build your Criteria queries.
(more...)
Categories
- Java (291)
- Agile (127)
- General (96)
- Architecture (47)
- Testing (45)
- Scrum (44)
- Performance (42)
- Podcast (31)
- SOA (25)
- Middleware (31)
- Deployment (20)
- Project Management (23)
- Xebia Labs (21)
- Quality Assurance (16)
- Tools (12)
- lean architecture (11)
- Articles (9)
- Virtualization (9)
- Security (7)