休眠一对多未返回完整结果集
||
我有一个带有多个子级（付款步骤）的休眠实体（工资级），并且正在尝试在应用程序中查询这些子级。不幸的是，我只能检索查询的第一条记录。这是实体
public class Paygrade extends Persistent {
@Id
@Column(length = 80, updatable=false)
private String code;
@Column(length = 80, updatable=false)
private String name;
@OneToMany(mappedBy = \"paygrade\", fetch = FetchType.LAZY)
@ForeignKey(name = \"none\")
private Set<Paystep> paygradeSteps = new HashSet<Paystep>();
// getters and setters
}
@IdClass(PaystepPK.class)
public class Paystep {
@Id
@Column(length = 80, updatable=false)
protected String gradeCode;
@Column(length = 80, updatable=false)
protected String gradeName;
@Id
@Column(length = 80, updatable=false)
protected String scaleCode;
@Column(length = 80, updatable=false)
protected String scaleName;
@Column(length = 80, updatable=false)
protected String scalePoint;
@Column(updatable=false)
protected Long scaleValue;
@ManyToOne
@ForeignKey(name = \"none\")
@JoinColumn (name=\"grade_code\", updatable = false, insertable = false)
private Paygrade paygrade;
// getters and setters
}
Hibernate:
/* load one-to-many ...Paygrade.paygradeSteps */ select
paygradest0_.grade_code as grade1_38_1_,
paygradest0_.grade_code as grade1_1_,
paygradest0_.scale_code as scale2_1_,
paygradest0_.grade_code as grade1_39_0_,
paygradest0_.scale_code as scale2_39_0_,
paygradest0_.grade_name as grade3_39_0_,
paygradest0_.scale_name as scale4_39_0_,
paygradest0_.scale_point as scale5_39_0_,
paygradest0_.scale_value as scale6_39_0_
from
tv_grade_point paygradest0_
where
paygradest0_.grade_code= \'Grade 9\'
没有找到相关结果
已邀请:
1 个回复
室邢
并使其相反。 顺便说一句：您问题中的SQL查询正在检索tv_grade_point，而不是Paystep。