Hello,

Is this strange mapping possible?

I have 2 classes.

Object and Relationship

I want object do have a Map, which the key would be Relationship, and the value would be a collection of other objects.

And if possible, the generated table beeing 3 pk, relationship's pk, source object's pk, and destination object's pk.

The use would be something like this:

Collection values = (Collection) obj.getRelationshipValues(relationship);

values have objects!

Thanks,
Felipe;

Your schema seems strange:)
could you give more details about your DB schema

Actually i'm not very worried about the database schema generated.

In one entity i want to have a map, with another entity as the key, and the value as a collection of the first entity.

Examples:

Relationship relationship = new Relationship();

Collection values = new HashSet();
values.add(new Object());
values.add(new Object());
values.add(new Object());

Object obj = new Object ();
obj.getRelationshipsValues().put(relationship, values);

What I'm doing is a generic database. My tables are:
Class, Object, Attribute, Relationship