JPA 2.0, Criteria API, Subqueries, In Expressions

by

Below is the pseudo-code for using sub-query using Criteria API. 

CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery<Object> criteriaQuery = criteriaBuilder.createQuery();
Root<EMPLOYEE> from = criteriaQuery.from(EMPLOYEE.class);
Path<Object> path = from.get("compare_field"); // field to map with sub-query
from.fetch("name");
from.fetch("id");
CriteriaQuery<Object> select = criteriaQuery.select(from);

Subquery<PROJECT> subquery = criteriaQuery.subquery(PROJECT.class);
Root fromProject = subquery.from(PROJECT.class);
subquery.select(fromProject.get("requiredColumnName")); // field to map with main-query
subquery.where(criteriaBuilder.and(criteriaBuilder.equal("name",name_value),criteriaBuilder.equal("id",id_value)));

select.where(criteriaBuilder.in(path).value(subquery));

TypedQuery<Object> typedQuery = entityManager.createQuery(select);
List<Object> resultList = typedQuery.getResultList();

Also it definitely needs some modification as I have tried to map it according to your query. Here is a link http://www.ibm.com/developerworks/java/library/j-typesafejpa/ which explains concept nicely.

More Related Contents:

  1. How do I count the number of rows returned by subquery?
  2. JPA CriteriaBuilder – How to use “IN” comparison operator
  3. Really dynamic JPA CriteriaBuilder
  4. JPA EntityManager: Why use persist() over merge()?
  5. JPA CascadeType.ALL does not delete orphans
  6. How can I validate two or more fields in combination?
  7. JPA 2.0 many-to-many with extra column
  8. JPA: unidirectional many-to-one and cascading delete
  9. JPA Query selecting only specific columns without using Criteria Query?
  10. @OrderColumn annotation in Hibernate 3.5
  11. JPA & Criteria API – Select only specific columns
  12. JPQL Constructor Expression – org.hibernate.hql.ast.QuerySyntaxException:Table is not mapped
  13. JPA Criteria API – How to add JOIN clause (as general sentence as possible)
  14. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  15. Spring batch jpaPagingItemReader why some rows are not read?
  16. Silently ignored remove()
  17. JPA Criteria builder IN clause query
  18. How to define unidirectional OneToMany relationship in JPA
  19. Hibernate generates negative id values when using a sequence
  20. JPA 2.0 native query results as map
  21. kotlin data class + bean validation jsr 303
  22. JPA transient information lost on create
  23. How do I do a “deep” fetch join in JPQL?
  24. Spring Data JPA and Querydsl to fetch subset of columns using bean/constructor projection
  25. Rollback on every checked exception, whenever I say @Transactional
  26. JPA Query to handle NULL parameter value
  27. JPA Criteria API group_concat usage
  28. Change Table Name of an Entity on runtime? [duplicate]
  29. JPA Select latest instance for each item
  30. Persist java.time.Instant (JDK8) with JPA2/Hibernate

Leave a Comment