Hibernate复合外键共享列

Question

@Embeddable
public class ID implements Serializable {
    private Long autoin;      // Surrogate key
    private Integer serverId; // instance identifier

    @Column(name = "autoin_fix")
    public Long getAutoin() {
        return this.autoin;
    }
    @Column(name = "servdat_fk")
    public Integer getServerId() {
        return this.serverId;
    }

    // ... setter, equals, hashCode ...
}

@Entity
@Table(name = "LEADS")
public class Request {
    private Long id;

    private Article article;
    private Location location;

    @Id
    @Column(name = "autoin_fix")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "auto-increment")
    @GenericGenerator(name = "auto-increment", strategy = "sequence",
            parameters = @org.hibernate.annotations.Parameter(name = "sequence", value = "AUTOINCREMENT"))
    public Long getId() {
        return this.id;
    }

    @ManyToOne
    @JoinColumns({
        @JoinColumn(name = "artikel_fk", referencedColumnName = "autoin_fix", 
                    insertable = false, updatable = false), // Here is the problem!
        @JoinColumn(name = "servdat_fk", referencedColumnName = "servdat_fk", 
                    insertable = false, updatable = false)
    })
    public Article getArticle() {
        return this.article;
    }

    @ManyToOne
    @JoinColumns({
        @JoinColumn(name = "standort_fk", referencedColumnName = "autoin_fix"),
        @JoinColumn(name = "servdat_fk", referencedColumnName = "servdat_fk")
    })
    public Location getLocation() {
        return this.location;
    }

    // Setters omitted
}

TABLE leads
-------------
autoin_fix
artikel_fk
standort_fk
servdat_fk  // This only exists once, but is part of the association to both Article and Location!

// This is illegal and the application won't start
@JoinColumns({
        @JoinColumn(name = "artikel_fk", referencedColumnName = "autoin_fix"),
        @JoinColumn(name = "servdat_fk", referencedColumnName = "servdat_fk", insertable = false, updatable = false)
    })

有人知道解决这个问题的办法吗？或者这是不可能使用Hibernate/JPA进行映射的吗？

Edit：Article和Location的（简化）定义（真的没那么有趣，重要的是它们使用了复合主键）：

@Entity
@Table(name = "ARTIKEL")
public class Article {
    private ID id;
    private String headline;
    private String description;

    @EmbeddedId
    public ID getId() {
        return this.id;
    }

    @Column(name = "artbesch")
    public String getDescription() {
        return this.description;
    }

    @Column(name = "artueschr")
    public String getHeadline() {
        return this.headline;
    }

    // Setters omitted
}

@Entity
@Table(name = "STANDORT")
public class Location {
    private ID id;
    private GeoCoordinates geoCoordinates;
    private Name name;

    @EmbeddedId
    public ID getId() {
        return this.id;
    }

    @Embedded
    public GeoCoordinates getGeoCoordinates() {
        return this.geoCoordinates;
    }

    @Embedded
    public Name getName() {
        return this.name;
    }

    // Setters omitted
}

Answer 1

我认为，如果依赖实体的派生标识符是嵌入式id类的形式，那么表示关系的id类的每个属性都应该由对应关系属性上的@Mapsid注释引用。

例如：

@Entity
public class Request {
    // ...
    @Id
    int id;

    @MapsId
    @ManyToOne
    private Article article;
    // ...
}

我希望这能奏效，因为我现在不能尝试。