Hibernate version: 3.4.2sp1

Name and version of the database you are using: Postgresql 8.2

I'm running into a mental brick wall trying to work around a problem in an existing database.

I have a main table ("Main"), and several other child tables ("ChildA", "ChildB", and so on).

I also have another table, "Info", that has an <any> relation to the "Main", and several of the "ChildX" tables.

I have in those "Main" and "ChildX" tables a <set> to create a collection of the associated "Info" rows. Works great.

However my headache starts when I want to have a <set> (or other collection type, I'm not tied to <set>) in "Main" which is a collection of the "Info" rows that are related to both "Main" and the "ChildX" rows related to "Main".

In other words if "Info" has 2 rows, 1 related to "Main" id "MAIN001", and 1 related to "CLDA001", with the "ChildA" row "CLDA001" related to "MAIN001", I want a collection in "Main" that would show both "Info" rows.

Another way to think of it is as a roll-up.

Any ideas?

The one I was thinking about most was adding a property to the "Info" mapping to hold the Id of the "Main" record that was related to it, but when doing one-to-many relations it actually has to be a column, not a property. :(

I draw a bit of a diagram to help show what I'm looking to try to do.



Any thoughts?