Hibernate version: 3.1


I can't make many-to-many mapping where Map's index located in entity table, not in relation table.

This is sample from Chapter 1.3.2. A unidirectional Set-based association (http://www.hibernate.org/hib_docs/v3/re ... -unidirset)


table EVENTS
*EVENT_ID
EVENT_DATE
TITLE


table PERSON_EVENT
*EVENT_ID
*PERSON_ID


table PERSON
*PERSON_ID
AGE
FIRSTNAME
LASTNAME




In my case I can't use Set, I need Map where index (key field for Map) is TITLE field in table EVENTS.




When I use this mapping I have error. In this case Hibernate search field "TITLE" in the table "PERSON_EVENT", not in the table "EVENTS".
Can anybody help me with mapping (without modification of database structure, i can't make "TITLE" as key field in table PERSON_EVENT)?

Sorry, my English isn't good.

I don't think there's any way to do this with Hibernate mappings. However, I guess you could use some custom code e.g.:

private Map<String, Event> titleEventMap;

public void setEvents(Map<Event> events) {
this.events = events;
for (Event e: events) {
// titleEventMap is an instance variable
titleEventMap.put(e.getTitle(), e);
}
}

public Map<String, Event> getTitleEventMap() {
return titleEventMap;
}

Thank you.
But in this case I should iterate all selected entities. Too long for me...