I'm having a problem in getting the proper HQL for the follwong senario:
I have done the many-to-many relationship mapping. (In this, the ITEM has a set of Orders and The Orders has a set of Items) ITEM is defined as the inverse end. The records for ITEM_ORDER table gets inserted when calling the session.save(order) and works fine.
Now, how to write the HQL to find out all the Orders objects that contains Item "ITM_01" ? In other words, i need to get all the Orders objects, that has Item "ITM_01" in their Item set.
Joined: Jun 28, 2004
oh, i found it and so impressed to see how simple it is :
subject: HQL query related to many-to-many relationship