有冬眠继承问题:@secondarytable注释

Question

我有以下类：

//Actor Class

@Entity
@Table(name=Actor.TABLE_NAME)  
@Inheritance(strategy=InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name="type")
@JsonIdentityInfo(generator=ObjectIdGenerators.PropertyGenerator.class, property="id")
public abstract class Actor{
    public static final String TABLE_NAME = "actor";
    @Id
    @Column(name="id")
    private String id = IdGenerator.createId();   
    public Actor() { }
    public String getId() { return id;  }
}

//公司类

@Entity
@SecondaryTable(name = Company.TABLE_NAME, pkJoinColumns= {@PrimaryKeyJoinColumn(name=Company.PK_NAME)})
@DiscriminatorValue("company")
public class Company extends Actor {
    public static final String TABLE_NAME = "company";
    public static final String PK_NAME = "id";
    // Inherits Id from superclass Actor
    @ManyToOne(cascade={CascadeType.PERSIST, CascadeType.MERGE}, fetch=FetchType.EAGER)
    @JoinColumn(name="categoryid") 
    private Category category;
    @Column(name = "name", nullable=false)
    @Size(min=2, max=60, message="LATER")
    private String name;
    @Column(name="domainName", nullable=true)
    private String domainName;  
    @Column(name="registrationNumber", nullable=true)
    private String registrationNumber;
    @Column(name="description")
    private String description;

    @OneToMany(cascade=CascadeType.ALL, fetch=FetchType.EAGER)
    @JoinColumn(name="itemId")
    private Set<Image> logos = new HashSet<>();
    @OneToMany(mappedBy="company", cascade=CascadeType.ALL, fetch=FetchType.LAZY)
    private Set<Branch> branches = new HashSet<>();
    public Company() {}
    public void addBranch(Branch branch) {
        branch.setCompany(this);
        branches.add(branch);
    }
    public void addLogo(Image logo) {
    }
// GETTERS AND SETTERS .......
}

//分支类

@Entity
@Table(name=Branch.TABLE_NAME)
public class Branch {
    public static final String TABLE_NAME = "branch";
    @Id
    @Column(name = "id")
    private String id = IdGenerator.createId();
    @OneToOne(cascade=CascadeType.ALL)
    @JoinColumn(name="address")
    private Address address;
    @Column(name = "telephone")
    private String telephone;
    @ManyToOne
    @JoinColumn(name="company")
    private Company company;
    public Branch() {
        this.address.setAddressCategory(AddressCategory.BRANCH); 
    }
// GETTERS AND SETTERS
}

//地址类

@Entity  
@Table(name=Address.TABLE_ADDRESS) 
public class Address {
    public static final String TABLE_ADDRESS = "address";
    @Id
    @Column(name="id")
    private String id = IdGenerator.createId();   
    @Column(name="category", nullable=false)
    private AddressCategory addressCategory;;
    @Column(name="streetname", nullable=true)
    private String streetName;
    @Column(name="number", nullable=true)
    private String number;
    @Column(name="postcode", nullable=true)
    private String postcode;
    @Column(name="city", nullable=true)
    private String city;
    @Column(name="country", nullable=true)
    private String country;
    @Column(name = "telephone")
    private String telephone;
    @Embedded
    private EmailAddress email;
    @Column(name="description", nullable=true)
    private String description;
    @ManyToOne
    @JoinColumn(name="actor")
    @NotNull(groups = {Update.class}) 
    @JsonIgnore
    private Actor actor;
    public Address() { }
    public Address(Actor actor) {
        this.actor = actor;
    }
// GETTERS AND SETTERS
}

当我使用Postman的以下JSON运行上述代码时：

{
    "categoryId": "ee6e75c9-2d1b-41c1-8f12-236fbf907683",
    "name": "McDonalds",
    "domainName": "www.McDonalds.be",
    "registrationNumber": "5555555",
    "description": "Food and Drink"
}

我得到以下例外：

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Field 'company0_.categoryid' not found in field list
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_151]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.8.0_151]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.8.0_151]
    at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.8.0_151]
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.44.jar:5.1.44]
    at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.44.jar:5.1.44]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) ~[mysql-connector-java-5.1.44.jar:5.1.44
...
...

请注意，我已经省略了控制器代码以简洁。上面的异常讨论了公司类中的 categoryId 属性。我删除了cangorid，异常用 description 属性替代了categoryId

我认为问题涉及使用辅助表的注释。

表如下：

CREATE TABLE actor
(
   id    VARCHAR(255)   DEFAULT '' NOT NULL,
   type  VARCHAR(255),
   PRIMARY KEY (id)
)

CREATE TABLE company
(
   id                    VARCHAR(255)   NOT NULL,
   categoryid            VARCHAR(255),
   name                  VARCHAR(255)   NOT NULL,
   `domainName`          VARCHAR(255)   NOT NULL,
   `registrationNumber`  VARCHAR(255),
   description           VARCHAR(255)   NOT NULL,
   PRIMARY KEY (id)
)
CREATE TABLE branch
(
   id         VARCHAR(255)   NOT NULL,
   company    VARCHAR(255),
   address    VARCHAR(255),
   telephone  VARCHAR(255),
   PRIMARY KEY (id)
)
CREATE TABLE address
(
   id           VARCHAR(255)   NOT NULL,
   category     VARCHAR(255),
   actor        VARCHAR(255),
   streetname   VARCHAR(255),
   number       VARCHAR(255),
   postcode     VARCHAR(255),
   city         VARCHAR(255),
   country      VARCHAR(255),
   telephone    VARCHAR(255),
   email        VARCHAR(255),
   description  VARCHAR(255),
   PRIMARY KEY (id)
)

Answer 1

在进行一些研究之后，我自己找到了答案。由于正在使用Company类上的@Secondarytable注释及其也从Actor继承，因此我必须指定哪个表Company的属性应持续存在。通过添加" Table = table_name" 在Company属性上的每个@Column注释中解决了问题。没有"表= table_name" 在@Column中，Hibernate将不知道是否将Company属性保存在 Actor Table或 Company Table。>