Hey, I'm trying to wrap my head around how to map the following relationship:

We have 3 tables.
Group:
Column ID
many other columns .....
Column FK_inventory_profile -> forign key to inventory profile.

Inventory_profile
Colum ID
Column name

Account_type
Column ID
Column name
Column FK_inventory_profile -> forign key to inventory profile.

Now on the object side, I have a Group object, that I want to have a Set containing all the names of the Account_types it is associated with.

All the documentation I can find assumes that Inventory_profile should have columns inside to to provide FK links to Group, and Account_type instead of vica-versa. Any help would be apreciated

- Luke

bump. Really need help with this!

Just map it.

Try
Group
many-to-one (inventory)

Account_type
many-to-one (inventory)

inv_profile
set one-to-many (Group) (no need to inv_profile column)
set one-to-many (Account_type)

look at the 5.9 section of the reference guide

HQL select accountType.name from AccountType as accountType inner join InvProfile as invProfile inner join Group as group where group.id = ?

look at 9.3. section

Thanks epbernard! I was kind of hoping I could map the relationship without 3 objects, because all I really need is a list of Account_type.name inside my group object. Nasty as it may be, I might consider changing the database schema a bit, even though it is difficult to do because we have several legacy systems that use it