All, I am pulling my hair out over this one!

COMPANY <1--*> COMPANY_MODULE_ASSOC <*--*> MODULE <1--*> PAGE


COMPANY_MODULE_ASSOC is not just a join table, it has an extra field called "enabled".

I went with the recomendations located here:
http://www.hibernate.org/hib_docs/reference/en/html/components.html and created a CompanyModuleAssoc class and mapped the above relationship like this:



Great. But now, a company can customize the content on one of the module pages. This means that there is a table named "CUSTOMIZED_PAGES" that is associated with the COMPANY_MODULE_ASSOC table.

How the heck do I do this in Hibernate? company_id, module_id and page_id would be a composite id in the CUSTOMIZED_PAGES table. Can I map a relationship to a composite?

Best Regards,

Joshua

All,

I am pretty stuck on this. This relationship is pretty out of the ordinary. Is there any other information that I can provide that would help?

Best Regards,

Joshua

I have no idea what you are trying to do, but almost certainly you will have more success mapping the class as an entity, instead of as a composite-element.

Gavin,

I will try to make this as clear as possible. I have included my table definitions below.

My application contains a number of MODULEs. Each MODULE has a number of PAGEs associated with it. A COMPANY can have MODULEs turned on using the MODULE table. This table is essentially a many-to-many table with an extra column, "enabled". I got this mapping to work by using a component (see my previous post in this thread).

Companies are able to customize the content of the PAGEs by specifying custom html in the CUSTOMIZED_PAGES table.

I have been unable to create a mapping between COMPANY_MODULE_ASSOC and the
CUSTOMIZED_PAGES table. As you can see below, CUSTOMIZED_PAGES also has a reference back to PAGE. Can you please help me with this?

Regards,

Joshua



Table Definitions:

Can you map the many-to-many relationship as an entity when the many-to-many table has an extra column? Looking in the docs, I have always seen it mapped using a component.

I am really stuck on this. I would appreciate your help.

Joshua