bookmark

Java Persistence/Criteria - Wikibooks, open books for an open world


Description

Criteria queries allow for multiple root level objects. Caution should be used when doing this, as it can result in Cartesian products of the two table. The where clause should ensure the two objects are joined in some way.

// Select the employees and the mailing addresses that have the same address. CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder(); CriteriaQuery criteriaQuery = criteriaBuilder.createQuery(); Root employee = criteriaQuery.from(Employee.class); Root address = criteriaQuery.from(MailingAddress.class); criteriaQuery.multiselect(employee, address); criteriaQuery.where(criteriaBuilder.equal(employee.get("address"), address.get("address")); Query query = entityManager.createQuery(criteriaQuery); List<Object[]> result = query.getResultList();

Preview

Tags

Users

  • @jil

Comments and Reviews