Join fetching @ManyToOne nested inside @OneToMany

Question

I have created the following entities to manage a persistent shopping cart:

ShoppingCart.java:

@Entity
public class ShoppingCart {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @PrivateOwned
    @OneToMany(mappedBy = "cart", cascade = CascadeType.ALL)
    @OrderBy("creationTimestamp")
    private List<ShoppingCartItem> items;

    public ShoppingCart() {}

    // Getters and setters...
}

ShoppingCartItem.java:

@Entity
@IdClass(ShoppingCartItemId.class)
public class ShoppingCartItem {
    @Id
    @ManyToOne
    private Item item;

    @Id
    @ManyToOne
    private ShoppingCart cart;

    private int quantity;

    @Column(precision = 17, scale = 2)
    private BigDecimal price;

    @Temporal(TemporalType.TIMESTAMP)
    private Date creationTimestamp;

    protected ShoppingCartItem() {}

    @PrePersist
    protected void prePersist() {
        creationTimestamp = new Date();
    }

    public ShoppingCartItem(ShoppingCart cart, Item item, int quantity) {
        this.cart = cart;
        this.item = item;
        this.quantity = quantity;
        this.price = item.getPrice();
    }

    // Getters and setters...
}

Item.java:

@Entity
public class Item {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @ManyToOne
    private Brand brand;

    private String model;
    private String variant;
    private String description;

    @Column(precision = 17, scale = 2)
    private BigDecimal price;

    private int availability;

    protected Item() {}

    // Constructors, getters and setters...
}

When I issue the the following JPQL query:

SELECT c FROM ShoppingCart c JOIN FETCH c.items WHERE c.id = :id

I notice that all the ShoppingCartItems in the same ShoppingCart are retrieved as expected in a single query but the @ManyToOne private Item item; field is not in the join and a separate query for each ShoppingCartItem is issued to fetch that field ~~when accessed~~.

Using EclipseLink, is there a way to have also the Items join fetched when join/batch fetching the ShoppingCartItems? How do I change the query and/or code?

score 1 · Answer 1 · answered Dec 24 '15 at 23:40

1

If you are using EclipseLink you can take a look at the @BatchFetch and @JoinFetch annotations.

answered Dec 24 '15 at 23:40

Patrick Leitermann

2,144
2
13
13

but then when using JPA and JPA handling is available, it would be unwise to do that (and throw away portability) – Dec 25 '15 at 09:18
1

Yes, that's true, but the question contained the term "Using EclipseLink, is there a way" and using annotations is much simpler and less error-prone than using string based JPQL or criteria queries. Maybe other proprietary features of EclipseLink are also used. – Patrick Leitermann Dec 25 '15 at 09:43

maurizeio · Accepted Answer · 2015-12-25T11:12:27.303

While the left join fetchs with aliases seems to be ignored, I've found this query hint that do the job:

Query query = entityManager.createQuery("SELECT c FROM ShoppingCart c WHERE c.id = :id");
query.setHint("eclipselink.left-join-fetch", "c.items.item.brand");

This is probably better than the annotation approach as it can be specified per single query.

UPDATE

Use of this hint broke @OrderBy("creationTimestamp") so ShoppingCartItems aren't returned in the order they were inserted anymore. This is probably due to a bug in EclipseLink but I think it doesn't really hurt so much since I actually need to have the items ordered only when showing the cart to the user and not, for example, when the user logs in and items in the anonymous cart must be transferred to the user cart.

Join fetching @ManyToOne nested inside @OneToMany

2 Answers2