Dear JPA experts,
I am trying to model a tree structure with ordered lists using @OrderColumn on a @ManyToMany + @JoinTable into both directions. I have put up a detailed question including an image here:
http://stackoverflow.com/questions/9957247/is-manytomanymappedby-ordercolumn-supported-by-the-jpa
I was wondering about three things (as taken from there):
1. Are @OrderColumn's supported for @ManyToMany(mappedBy = ...) + @JoinTable (inverse bi-dir relationship)?
2. Are @OrderColumn's also being part of a foreign key supposed to be supported, even though the JPA spec remains silent about this? I see no reason why not requiring all JPA implementations to support this.
3. Because Hibernate throws a MappingException on 2., does this probably qualify as a bug?
I'd very much appreciate your input on this.
Thanks
Karsten Wutzke