HQL query joining three Hibernate entity classes

Asked Aug 10 '21 at 23:39

Active Aug 11 '21 at 21:02

Viewed 19 times

I have three Hibernate entity classes - Shipment, Parcel and User - mapping respectively tables shipments, parcels and users (see attached db scheme). Parcels represent the "connection point" between a User and a Shipment as each parcel has an user_id and a shipment_id.

What I need to do is write an HQL query that filters shipments by user_id. How can I do that? Thanks.

edited Aug 11 '21 at 21:02

bobndrew

asked Aug 10 '21 at 23:39

Ivan Simeonov

Post your entities. Without them, I could only assume how mappings look like and suggest something like `select s from Shipment s join s.parcels p join p.users u where u.id = :userId`. – Stefan Golubović Aug 12 '21 at 14:06
Thank you, Stefan. Eventually, I found it in the hard way. – Ivan Simeonov Aug 15 '21 at 16:47

HQL query joining three Hibernate entity classes

0 Answers0