Hibernate Mapping of nested collection in java to mapping table through java annotation?

Question

Problem too specific.closing the same.

Answer 1

It is possible to map a ManyToMany association using a Map, and a typicall use case for this kind of mapping is when you have a ternary association. For example, if you have:

STUDENT_TEACHER_COURSE
STUDENT_ID(FK, PK)
TEACHER_ID(FK, PK)
COURSE_ID (FK, PK)

Then you could define the following mapping (assuming you're using a Hibernate Annotations < 3.5):

@Entity
public class Student {
    ...
    @ManyToMany
    @JoinTable(
        name="STUDENT_TEACHER_COURSE", 
        joinColumns= { @JoinColumn(name="STUDENT_ID") },
        inverseJoinColumns= { @JoinColumn(name="TEACHER_ID") }
    )
    @MapKeyManyToMany(joinColumns = @JoinColumn(name="COURSE_ID",unique = false))
    protected Map<Course,Teacher> teachers ;
    ...
}

But I don't think you can have a "nested" List<Teacher> as value inside the Map, I don't think Hibernate can map that and I'd consider getting the List from an entity instead.

References

• Hibernate Annotations 3.4 Reference Guide
  • 2.4.6.2.2. Map
• Hibernate Annotations 3.5 Reference Guide
  • 2.2.5.3.4. Indexed collections (List, Map)

Resources

• @MapKeyManyToMany and value column name
• Help with annotations -- Map