Two collections manyToOne to same primary key

Question

Hi, guys,

I'm coding a web page in Hibernate-JPA and Oracle.

I need the following:

I have two classes: Place and Home.

I need two collections of type Place in every Home: I do the following:

Home:

@ManyToOne
@JoinColumn(name="ID_PLACES")
private List<Places>places1;

@ManyToOne
@JoinColumn(name="ID_PLACES")
private List<Places>Places2;

However, hibernate got an exception (repeated column) and forces to me to mapping with insert and update to false.

How Can I get Two ManyToOne relationship to same primary key with insert a true?.

Answer 1

Yeah, but in other side, I must put:

@ManyToOne @JoinColumn(name="ID_PLACES") private Place place1;

@ManyToOne @JoinColumn(name="ID_PLACES") private Place place2;

isn't it?. There is my error: related to same primary key.

Thanks for your quick response, of course.