我有以下实体:
@Entity
@Table(name = "employee")
@Inheritance(strategy = InheritanceType.JOINED)
@DiscriminatorColumn(name="TYPE")
public class Employee {}
@Entity
@Table(name = "regular_employee")
@PrimaryKeyJoinColumn(name = "id")
@DiscriminatorValue("R")
public class RegularEmployee extends Employee{}hibernate在查询中没有使用鉴别器的问题。
select
employee0_.id as id1_1_,
employee0_.name as name2_1_,
employee0_.type as type3_1_,
employee0_1_.pay_per_hour as pay_per_1_0_,
case
when employee0_1_.id is not null then 1
when employee0_.id is not null then 0
end as clazz_
from
employee employee0_
left outer join
regular_employee employee0_1_
on employee0_.id=employee0_1_.id hibernate不应该在"left jouter join“部分使用鉴别器的值吗?类似于:
left outer join
regular_employee employee0_1_
on employee0_.type='R' and employee0_.id=employee0_1_.id我猜这会带来性能上的提升。
谢谢,泰金。
发布于 2015-04-02 04:32:22
当使用联合继承策略和左连接时,不需要鉴别器值来获取所需的数据。在这种情况下,JPA规范并没有强制使用鉴别器--在对Hibernate 4: persisting InheritanceType.JOINED discriminator column values的回答中解释了这一点。
也就是说,Hibernate团队似乎非常自豪,因为他们不需要使用鉴别器值,这可以从评论HHH-6911中观察到。
https://stackoverflow.com/questions/29394696
复制相似问题