Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1.3

Name and version of the database you are using: Oracle 9i


Hi, I've been implementing a lot of searching with the Criteria API recently. What a great API! Love it! There's one more thing I haven't figured out how to do though: paging the combined result of 2 (or more) criteria(s?).

In our search page, we search different entities based on user's selection. The problem comes because there's an option "All" ;-) Basically then I need to do searching on entity A and B, and combine the results into one big search result page. Any idea whether it's possible to combine this using Hibernate, or I must do the paging manually?

Cheers!
Ray

Ah, silly me. This is not a Hibernate problem but a database problem. I created a view that is a union of the two entities, and use Criteria API against that view.

It works perfectly.