Eclipse Community Forums: EclipseLink » Constraint violation with @OrderColumn

Help

Home

Home » Eclipse Projects » EclipseLink » Constraint violation with @OrderColumn

Show: Today's Messages :: Show Polls :: Message Navigator

Constraint violation with @OrderColumn [message #1752859]

Sun, 29 January 2017 19:04

Marc Dzaebel

Messages: 10
Registered: July 2009

Junior Member

I get a violation of a primary key constraint of the join table, that is automatically created by EclipseLink for the following classes:

@Entity public class Link {
    @ManyToMany @OrderColumn
    private List<Node> nodes; ...

@Entity public class Node {
    @ManyToMany(fetch = FetchType.EAGER, mappedBy = "nodes") 
    private List<Link> links; ...

The violation occurrs, if I insert a Link with the same Node on first and second position of it's nodes. Indeed there is a generated index with NODES_ID and LINKS_ID (missing NODES_ORDER). How could I influence EclipseLink in order to ommit or extend this constraint?

Using: Glassfish 4.1.1, EclipseLink 2.6.4 or 2.7.0, Java 8

Report message to a moderator