java - spring 数据查找顶部和复合键 id

Question

您好，我正在尝试进行查询以选择我的实体，如下所示:

• 获取对复合ID的一个属性有限制的实体
• 以及对复合id的第二个属性的限制(获取Top(max))

这是我的 Lot 实体

@EmbeddedId
@AttributeOverrides({ @AttributeOverride(name = "idLot", column = @Column(name = "id_lot", nullable = false)),
@AttributeOverride(name = "versionLot", column = @Column(name = "version_lot", nullable = false, length = 10)) })
public LotId getId() {
        return this.id;
}
    ...

复合ID

@Embeddable
public class LotId implements java.io.Serializable {

    private int idLot;
    private int versionLot;
...

和我的查询

public List<Lot> findTopById_VersionLotAndId_IdLot(@Param("identifiant") int idLot);

这给了我

Caused by: java.lang.IllegalArgumentException: No parameter available for part id SIMPLE_PROPERTY (1): [Is, Equals] NEVER.

Answer 1

这就成功了

Optional<Lot> findTopById_IdLotOrderById_VersionLotDesc(@Param("identifiant") int idIdLot);