Revision history [back]

To retrieve data from a table that is included in a JPA join using Hibernate, you can use the following steps:

1. Create a JPA query that includes the join statement that specifies the table you want to retrieve data from. For example, you can use the following query to retrieve data from a table named 'orders':

SELECT o FROM Customer c JOIN c.orders o WHERE c.id = :customerId

1. Call the JPA Query object's 'setParameter' method to set the value of the 'customerId' parameter. For example:

Query query = entityManager.createQuery("SELECT o FROM Customer c JOIN c.orders o WHERE c.id = :customerId");
query.setParameter("customerId", customerId);

1. Invoke the getResultList() method of the query object to retrieve the list of results. For example:

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

1. You can now use the 'orders' variable to access the data from the 'orders' table that was retrieved as a part of the join.

for (Order order : orders) {
    System.out.println("Order " + order.getId() + " was placed on " + order.getOrderDate());
}