Hi, I'm having some issues with a Many To Many Mapping.
I have two Tables (TABLE1, TABLE2) each having a Primary Key named ID and another Column named NUMBER.
Additionally I have a Join Table (TABLE1_TABLE2) with two columns NUMBER1 and NUMBER2.
What I want is a Many To Many Join using the NUMBER columns and not the ID columns.
I tried this, but it's not working...it always uses the ID columns no matter what I try.

@ManyToMany
@JoinColumn(name="NUMBER", referencedColumnName="NUMBER")
@JoinTable(joinColumns=@JoinColumn(name="NUMBER1"),
inverseJoinColumns=@JoinColumn(name="NUMBER2"))

and

@ManyToMany
@JoinColumn(name="NUMBER")
@JoinTable(joinColumns=@JoinColumn(name="NUMBER1"),
inverseJoinColumns=@JoinColumn(name="NUMBER2", referencedColumnName="NUMBER"))

I can't find anything about this usecase for a Many To Many Mapping.
Hopefully somebody of you can help me.
Frank

I think the correct Annotation is:

@ManyToMany
@JoinTable(joinColumns=@JoinColumn(name="NUMBER1", referencedColumnName="NUMBER")),
inverseJoinColumns=@JoinColumn(name="NUMBER2", referencedColumnName="NUMBER"))

But now I'm facing the next problem...
Im trying to perform a many-to-many self-join,but with the Example above i get an error that says:
Duplicate property mapping ....

It looks like you can't have a many-to-many relationship to the same object using a non primary key column!!!

Is that a bug in hibernate??