What is the correct way to convert the JPQL "join fetch" with a "where" clause into a JPA 2 CriteriaQuery?

edit

To convert the JPQL "join fetch" with a "where" clause into a JPA 2 CriteriaQuery, you can follow the below steps:

1. Create a CriteriaBuilder instance:

CriteriaBuilder cb = entityManager.getCriteriaBuilder();

1. Create a CriteriaQuery instance with the desired result type:

CriteriaQuery<Order> query = cb.createQuery(Order.class);

1. Specify the root entity for the query:

Root<Order> orderRoot = query.from(Order.class);

1. Add a join fetch to the query using the root entity:

orderRoot.fetch("customer", JoinType.INNER);

1. Add the where clause to the query using the CriteriaBuilder:

Predicate predicate = cb.equal(orderRoot.get("status"), "PROCESSING");
query.where(predicate);

1. Execute the query using your entity manager:

List<Order> orders = entityManager.createQuery(query).getResultList();