I have a table (REPORT) which contains 3 columns:

GROUP
REPORT_NAME
CLASS
PROCESS

All of these are part of the primary key. I would like to create an object model such that a GROUP object contains a collection of REPORT objects, each of which has a name, class and process as properties.

Is this possible to do in hibernate, given that there is only one table

cheers,

rob

Don't think this is possible in an easy way.

No, I can't think of any easy way either. Can you think of any hard way?
Basically, out of the back of the mapping, I somehow need to generate 2 objects instead of one: one for the grouping and one for the row.

I was thinking perhaps I should use some kind of custom-value type might do it. Or maybe even a composite key. Somehow I could use a type of singleton so that each key with the same group has a reference to the group in it.

There are actually a couple of different places in the (really bad) schema I'm working with where this would really come in useful.

Actually the only thing that comes to my mind currently is writing a custom ClassPersister, which is HARD. I am not so sure you could be able to do it that way, as you essentially are trying to map one object to multiple table rows.

Actually I would really try to solve this on the database side, using some views or something. I have the strong feeling this is a MySql db though ...

I came across this and was wondering if anyone had found a reasonable solution to this to date?

I ended up doing something similar, using a <subselect> in the equivalent of the GROUP mapping discussed above. This page has a decent description of the approach:
http://blog.exadel.com/?p=16

The problem was that doing a select distinct on the table I was using was far too slow.

Just curious if anyone else has any thoughts.

-Matt