JavaHibernate加入继承（id未找到）

Question

对不起，我的英语不是我的母语，而且已经两点钟了，所以现在不能思考了。现在，在将hibernate与Java和PostgreSQL一起使用时，我遇到了下一个问题：我有如下实体Human和User（带有注释映射）：

    @Inheritance(strategy = InheritanceType.JOINED)
    public class Human implements Serializable{
        private static final long serialVersionUID = 1L;
        public static enum Gender{
            Male,
            Female}
        @Id
        @GeneratedValue
        private Integer id;
        @Enumerated(EnumType.STRING)
        private Gender gender;
        @Column
        @Temporal(TemporalType.DATE)
        private Date dateOfBirth;
        private String firstName;
        private String middleName;
        private String lastName;
        // getters,setters
    }

    @Entity
    @PrimaryKeyJoinColumn
    public class User extends Human{
        private static final long serialVersionUID= 1L;
        @Column
        @Temporal(TemporalType.DATE)
        private Date registrationDate;
        private Boolean activationStatus;
        private String activationCode;
        private String login;
        private String password;
        private String sessionCode;
        private String email;
        private String country;
        private String city;
        private String avatarURL;
        private String description;
        // getters,setters
    }

和数据库结构如下：

human
(
  dateofbirth date NOT NULL,
  firstname text NOT NULL,
  middlename text NOT NULL,
  lastname text NOT NULL,
  id serial NOT NULL,
  gender text,
  CONSTRAINT "Human_id" PRIMARY KEY (id )
)
"user"
(
  login text NOT NULL,
  password text NOT NULL,
  activationcode text NOT NULL,
  activationstatus status NOT NULL,
  avatarurl text NOT NULL,
  city text NOT NULL,
  country text NOT NULL,
  description text NOT NULL,
  registrationdate date NOT NULL,
  email text NOT NULL,
  id integer,
  CONSTRAINT uid PRIMARY KEY (id )
)

当我尝试运行我的项目（简单单元测试）时，我得到下一个错误：

    org.postgresql.util.PSQLException: ERROR: column human0_1_.id does not exist
      Позиция: 778
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
        at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
        at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
        at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
        at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
        at org.tempos.server.modules.users.HumanTest.testGetId(HumanTest.java:31)
...

（我剪掉了日志的尾部，而它在JUnit方法中响应invokin）。

生成的查询（失败）：

select human0_.id as id3_0_, human0_.dateOfBirth as dateOfBi2_3_0_, human0_.firstName as firstName3_0_, human0_.gender as gender3_0_, human0_.lastName as lastName3_0_, human0_.middleName as middleName3_0_, human0_1_.activationCode as activati1_4_0_, human0_1_.activationStatus as activati2_4_0_, human0_1_.avatarURL as avatarURL4_0_, human0_1_.city as city4_0_, human0_1_.country as country4_0_, human0_1_.description as descript6_4_0_, human0_1_.email as email4_0_, human0_1_.login as login4_0_, human0_1_.password as password4_0_, human0_1_.registrationDate as registr10_4_0_, human0_1_.sessionCode as session11_4_0_, case when human0_1_.id is not null then 1 when human0_.id is not null then 0 end as clazz_0_ from Human human0_ left outer join User human0_1_ on human0_.id=human0_1_.id where human0_.id=?

可以看到，它试图在human1_1_. id（最初是User.id）上加入列，但没有在查询的SELECT部分指定和获得。

我所尝试的：

1. 创建@列私有整数id在类用户（得到注释解析器异常重写类的主列）；
2. 创建@列私有整数隐藏在类用户中，并将其设置为PrimaryKeyJoinColsta（但我得到了（应与插入映射="假"更新="假"），即使我将其映射为@JoinColiv（插入=假，可更新=假，引用的列名称="id"））；
3. 创建的列隐藏，并指出它作为PrimaryKeyJoinColsta在注释列本身，而不是整个类（得到了相同的错误，在原来的列human0_1_. id未找到）；

任何人，请给我一些想法！

Answer 1

您的类应该如下所示：
Human

import java.io.Serializable;

import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Inheritance;
import javax.persistence.InheritanceType;

@Entity
@Inheritance(strategy = InheritanceType.JOINED)
public class Human implements Serializable {

    private static final long serialVersionUID = 1L;

    public static enum Gender {
        Male, Female
    }

    @Id
    @GeneratedValue
    private Long id;

    @Enumerated(EnumType.STRING)
    private Gender gender;
    private String firstName;
    private String lastName;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public Gender getGender() {
        return gender;
    }

    public void setGender(Gender gender) {
        this.gender = gender;
    }

    public String getFirstName() {
        return firstName;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }
   .....
}

用户

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.PrimaryKeyJoinColumn;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

@Entity
@PrimaryKeyJoinColumn
public class User extends Human {

    private static final long serialVersionUID = 1L;

    @Column
    @Temporal(TemporalType.DATE)
    private Date registrationDate;

    public Date getRegistrationDate() {
        return registrationDate;
    }

    public void setRegistrationDate(Date registrationDate) {
        this.registrationDate = registrationDate;
    }
    ....
}

• 人类类应该由@Entity注释注释
• 模型实体类应该实现可串行化接口

看到没

1. 继承类型（带有Hibernate）。
2. 继承类型加入

Answer 2

问题解决了，主要是因为myhaylo
此问题的原始原因一直由SQE PMD插件标记——“User”是SQL-99语法中的关键字。因此（看起来像），需要引用表名。它在PgAdmin查询浏览器中引用，但在Hibernate生成的查询中没有引用，事实上，在这种情况下，human0_1_中也没有引用。id，它必须指向用户。身份证，没有指向任何地方
将类和表名更改为其他名称（如AndhorUser）后，现在发布的原始数据库结构和类定义运行良好。