I have 3 entities: OrderHeader, OrderLocationHeader, and OrderDetail

The relationships are as follows:
OrderHeader -> OrderLocationHeader (1:M)
OrderHeader -> OrderDetail (1:M)
OrderLocationHeader -> OrderDetail (1:M).

Each entity uses the following EmbeddedIds:
OrderHeaderId (Integer season, String number)
OrderLocationHeaderId (OrderHeader header, PickupLocation pickupLocation)
OrderDetailId (OrderHeader header, Integer sequence)

PickupLocation is also an Emeddable (Integer exchange, Integer association, Integer packingHouse)

When hibernate tries to join OrderDetail to OrderLocationHeader, this is the SQL that is generated:

If all the "locationHeader_OL" pieces were "OD", I would be good. I've tried the various JPA Override annotations among other things to no avail.

Please advise. Thanks!

I managed to solve this on my own. By making OrderLocationHeader the parent of OrderDetail (OrderDetailId (OrderLocationHeader locationHeader, Integer sequence)) and by using a mix of @AttributeOverrides and @AssociationOverrides, I was able to get the mappings to work properly. Then, I was also able to create a direct link between Header and Detail. On the Detail, I just had to declare the @JoinColumns as not insertable/updatable (since they will be set via the Id)