使用EmbeddedIdHibernate条件

Question

我有我的实体：

@Entity
@Table(name="performances")
@AssociationOverrides({
    @AssociationOverride(name="id.player", joinColumns=@JoinColumn(name="player_id")),
    @AssociationOverride(name="id.season", joinColumns=@JoinColumn(name="season_id"))
})
public class Performance extends AbstractEntity<PerformanceID> {

    private static final long serialVersionUID = 1L;

    @EmbeddedId
    @Getter @Setter
    private PerformanceID id;
    @Getter @Setter
    private int goals;

    public Player getPlayer(){
        return id.getPlayer();
    }

    public Season getSeason(){
        return id.getSeason();
    }

和：

@Embeddable
public class PerformanceID implements Serializable {

    private static final long serialVersionUID = 1L;

    @ManyToOne(fetch=FetchType.LAZY, targetEntity=Player.class)
    @JoinColumn(name="player_id")
    @Getter @Setter
    private Player player;
    @ManyToOne(fetch=FetchType.LAZY, targetEntity=Season.class)
    @JoinColumn(name="season_id")
    @Getter @Setter
    private Season season;

Query query = getSession().createQuery("from Performance where id.player.name = 'Claudio'");
return query.list();

Criteria criteria = getSession().createCriteria(Performance.class);
criteria.add(Restrictions.ilike("id.player.name", "Claudio"));
return criteria.list();

Criteria criteria = createCriteria();
criteria.createAlias("id.player", "player");
criteria.add(Restrictions.ilike("player.name", "Claudio"));
return criteria.list();

Hibernate:this_.player_id选为player2_1_0_,this_.season_id选为season3_1_0_,this_.goals选为goals1_0_？

但它将失败,并出现SQLGrammarException：“Missing FROM clause for table player1_”

Answer 1

您的映射不正确。EmbeddableId类应该包含@id（因此Serializable)值，而不是映射或复杂类型。您应该将映射移动到实体类中，然后只在embbedableid类中包含它们的ID。请参阅以下示例（来自JPA2.2规范）

@Embeddable
public class DependentId {
    String name;
    long empPK;   // corresponds to PK type of Employee
}

@Entity
public class Dependent {
    @EmbeddedId DependentId id;

    // id attribute mapped by join column default
    @MapsId("empPK") // maps empPK attribute of embedded id
    @ManyToOne Employee emp;
}