It it possible to use @MappedBy with @ManyToMany?


I.E.

Person
@NotNull
@ManyToMany(cascade = { CascadeType.REFRESH }, fetch = FetchType.LAZY, mappedBy=authors)
private List<Person> authors = new ArrayList<Articles>();


Article
@NotNull
@ManyToMany(cascade = { CascadeType.REFRESH }, fetch = FetchType.LAZY)
@Cascade( { org.hibernate.annotations.CascadeType.DETACH, org.hibernate.annotations.CascadeType.LOCK, org.hibernate.annotations.CascadeType.REFRESH, org.hibernate.annotations.CascadeType.REPLICATE })
private List<Person> authors = new ArrayList<Person>();

Hi,
Its possible. Here is what I have used. For my example, the two entities are Category and Item. A Category may contain many Items and similarly an Item may belong to multiple Categories. Here is the code that I have used and is working.

In Category.java


In Item.java


In this case an intermediate table is constructed by Hibernate though. If you want to explicitly control the intermediate table attributes, you can use @JoinTable. In either case, you need to map only the one side of Collection. The other can be specified by "mappedBy". Hope this helps.

regards,
Nirvan.

I need to do some more testing but from what I can tell this isn't working right.

Hibernate created an "id field" for both sides of the relationship, which seems to be that it wouldn't work as a mapped by.

I got this to work, but in order to do so I had to explicitly define the join table.

Otherwise it was looking for an articles_id column when loading Person and a authors_id column when loading Article.
After explicitly defining the join table & columns it is working just fine.

I'm using 3.5.1-FINAL



Person


Article