在一对一关系中查询JPA TABLE_PER_CLASS映射 [英] Quering JPA TABLE_PER_CLASS mapping on One to One relationship

问题描述

我正在尝试使用继承策略TABLE_PER_CLASS映射JPA(使用Hibernate)一对一关系.这是一个示例:

I am trying to map a JPA (using Hibernate) one-to-one relationship with a inheritance strategy TABLE_PER_CLASS. Here is an example:

@Entity
public class DrivingLicense {

    @OneToOne(targetEntity = Human.class, cascade = CascadeType.ALL, fetch=FetchType.LAZY)
    @JoinColumn
    private Human human;

    @SuppressWarnings("unchecked")
    public static List<DrivingLicense> findMansDrivingLicenses(Long id) {
        if (id == null) return null;
        return entityManager()
            .createQuery("select o from DrivingLicense o left join fetch o.human where o.id = :id")
            .setParameter("id", id)
            .getResultList();
    }

}

@Entity
@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)
public abstract class Human {
   ...
}

@Entity
public class Man extends Human {
   ...
}

@Entity
public class Mutant extends Human {
   ...
}

当我调用"findMansDrivingLicenses"以检索所有人的驾驶执照时，冬眠会对两个表(MAN和MUTANT)执行"UNION ALL".遵循日志输出:

When I call "findMansDrivingLicenses" to retrieve all man's driving licenses hibernate does a "UNION ALL" with both tables (MAN and MUTANT). Follow the log output:

select
        drivinglic0_.id as id3_0_,
        human1_.id as id0_1_,
        drivinglic0_.first_name as first2_3_0_,
        drivinglic0_.human as human3_0_,
        drivinglic0_.last_name as last3_3_0_,
        drivinglic0_.type as type3_0_,
        drivinglic0_.version as version3_0_,
        human1_.version as version0_1_,
        human1_.comment as comment1_1_,
        human1_.behavior as behavior2_1_,
        human1_.clazz_ as clazz_1_ 
    from
        driving_license drivinglic0_ 
    left outer join
        (
            select
                id,
                version,
                comment,
                null as behavior,
                1 as clazz_ 
            from
                man 
            union
            all select
                id,
                version,
                null as comment,
                behavior,
                2 as clazz_ 
            from
                mutant 
        ) human1_ 
            on drivinglic0_.human=human1_.id 
    where
        drivinglic0_.id=?

有什么方法可以防止休眠状态执行"UNION ALL"并且仅与MAN表联接吗?

Is there any way to prevent hibernate to do this "UNION ALL" and only join with MAN table?

推荐答案

尝试使用类

select o from DrivingLicense o left join fetch o.human human where o.id = :id and human.class = Man

更新

检索与本机查询的关系

session = sessionFactory.openSession();

StringBuilder query = new StringBuilder();
query
.append("select ")
    .append("{driving.*}, {man.*} ")
.append("from ")
    .append("DrivingLicense driving ")
.append("left join ")
    .append("Man man ")
.append("on ")
    .append("driving.human_id = man.id ")
.append("where ")
    .append("driving.id = :id");

Query _query = session.createSQLQuery(query.toString())
                      /**
                        * It means: driving alias WILL BE MAPPED TO DrivingLicense Entity
                        */
                      .addEntity("driving", DrivingLicense.class)
                      /**
                        * It means: man alias WILL BE MAPPED TO human property of DrivingLicense Entity
                        */
                      .addJoin("man", "driving.human")
                      .setParameter("id", <DRIVING_LICENSE_ID_GOES_HERE>);


Object [] resultArray = query.list.get(0);

session.close();

还有

DrivingLicense driving = resultArray[0];
/**
  * YES, Man IS NOT automatically MAPPED TO driving.human property
  * You have to set up manually
  */
Man man = resultArray[1];

driving.setHuman(man);

这篇关于在一对一关系中查询JPA TABLE_PER_CLASS映射的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！