Hibernate Tip: How to implement a subquery in a CriteriaQuery

preview_player
Показать описание

One of the readers of my blog asked me the following question: In one of our use cases, we use the Criteria API to build the query dynamically. Now I need to add a subquery. Does the Criteria API support subqueries? And how can I implement them?
Yes, you can use sub queries in your CriteriaQuery and I will show you how in this video. But before we jump in, please subscribe to this channel and turn on the notification so that you don’t miss any future Hibernate tips.

If you like this video, please give me your thumbs up and share it with your friends and co-workers.

Like my channel? Subscribe!

Join the free Member Library:

Want to connect with me?
  1. Thorben Janssen
  2. Hibernate
  3. JPA
  4. Hibernate Tip
  5. Criteria API
  6. Query
Рекомендации по теме
Hibernate Tip: How 0:03:56

Hibernate Tip: How to implement a subquery in a CriteriaQuery

Hibernate Tip: How 0:03:27

Hibernate Tip: How to use a custom database sequence

Hibernate Tip - 0:03:33

Hibernate Tip - How to map an association to a java.util.Map

Hibernate Tip: How 0:03:59

Hibernate Tip: How To Map an Entity to a Query

Hibernate Tip: How 0:03:08

Hibernate Tip: How to create a database setup script based on entity mappings

Hibernate Tip: How 0:02:36

Hibernate Tip: How to use the QueryCache to avoid additional queries

Hibernate Tip: How 0:04:39

Hibernate Tip: How to map native query results to managed entities

Hibernate Tip - 0:02:38

Hibernate Tip - How to bootstrap Hibernate with Spring Boot

Hibernate & JPA 0:24:27

Hibernate & JPA Tutorial - Crash Course

Hibernate Tips ‘n’ 0:45:48

Hibernate Tips ‘n’ Tricks - 15 Tips to solve common problems by Thorben Janssen

Hibernate Tip : 0:03:03

Hibernate Tip : How to avoid MultipleBagFetchException

Hibernate Tip: How 0:04:41

Hibernate Tip: How to integrate an external query builder

Hibernate Tip - 0:03:31

Hibernate Tip - How to use pagination with JPQL

Hibernate Tip: How 0:05:26

Hibernate Tip: How to map the latest element of an association

Hibernate Tip: How 0:04:06

Hibernate Tip: How does Hibernate’s native ID generator work?

Hibernate Tip: How 0:03:31

Hibernate Tip: How to Share the Primary Key in a One-to-One Association

Hibernate Tip : 0:03:42

Hibernate Tip : How to create and initialize a database

Hibernate Tip: How 0:04:33

Hibernate Tip: How to persist a List of Strings as an ElementCollection

Hibernate Tips: How 0:04:58

Hibernate Tips: How to use Hibernate's native bootstrapping API

Hibernate Tip: Easiest 0:05:00

Hibernate Tip: Easiest way to manage bi-directional associations

Hibernate Tip - 0:02:42

Hibernate Tip - How to log SQL statements and their parameters

Hibernate Tip: How 0:03:29

Hibernate Tip: How to map an entity attribute to an Optional

Hibernate Tip: Customize 0:04:07

Hibernate Tip: Customize the association mappings using a composite key

Hibernate Tip: How 0:03:53

Hibernate Tip: How to override column mappings of a superclass

Комментарии
Автор

Do you need to join them? I’m trying to do a not in to retrieve records that’s not on the other table

Cons
Автор

Hi Sir, your video and explanation is very helpful.

amidalashiva
Автор

Thanks for sharing! Question for you... what's the underscore? e.g. Book_.authors, Author_.id, etc.

gamatossian
Автор

How can we do something similar to a subquery in the select using critaria API, I already heard you say it can't be done, but is there any trick with criteria API that we can simulate a subquery in a select?. Thanks
Well, I think it would be referencing a column from a join with the other table.

compartelo
Автор

How to get columns with embedded entity

akshaypande