Executing a subquery using a criteria
In this recipe, we will take a look at how to use subquery. Here, we will do the same thing as before; we will use the DetachedCriteria
class provided by the hibernate API. The DetachedCriteria
class works in detached mode
and is used to create a criteria query when the session is not available, as we can execute DetachedCriteria
with the existing session object.
How to do it…
We will create one scenario to show how DetachedCriteria
acts as a subquery.
The scenario is to get all the products whose categories have been recently added.
The preferred solution for this problem is as follows:
- First, we will create
DetachedCriteria
to find the maximumcreatedOn
date - Then, we will use the result of the first query to check ...
Get Java Hibernate Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.