java - Hibernate可嵌入类中的可选字段

我有一个Embeddedable类，地址。这个想法是使用@AttributeOverride（s）映射到旧数据库模式。但是，我希望这些字段是可选的。例如，并非每条记录都有STREET_ADDRESS_2。

下面的类可以持久地保存/保存到数据库，但是在执行getAll（）操作时会出现“ java.sql.SQLSyntaxErrorException：用户缺少特权或找不到对象”的提示。具体来说，getStreet2（）方法会引起问题。

@Embeddable
public class Address implements Serializable {

private static final long serialVersionUID = 1L;

private String street1;
private String street2;
private String state;
private String zip;
private String city;
private String phone;

@Column(name = "STREET1", updatable=false, insertable=false)
public String getStreet1() {
    return street1;
}

public void setStreet1(String street1) {
    this.street1 = street1;
}

//@Basic(optional=true)
@Column(name="STREET2", insertable=false, updatable=false)
@NotFound(action=NotFoundAction.IGNORE)
public String getStreet2() {
    return street2;
}

public void setStreet2(String street2) {
    this.street2 = street2;
}

@Column(name="STATE", updatable=false, insertable=false)
public String getState() {
    return state;
}

public void setState(String state) {
    this.state = state;
}

@Column(name="ZIP", updatable=false, insertable=false)
public String getZip() {
    return zip;
}

public void setZip(String zip) {
    this.zip = zip;
}

@Column(name="CITY", updatable=false, insertable=false)
public String getCity() {
    return city;
}

public void setCity(String city) {
    this.city = city;
}

@Column(name="PHONE", updatable=false, insertable=false)
public String getPhone() {
    return phone;
}

public void setPhone(String phone) {
    this.phone = phone;
}

@Override
public String toString() {
    return "Address [street1=" + street1 + ", street2=" + street2
            + ", state=" + state + ", zip=" + zip + ", city=" + city
            + ", phone=" + phone + "]";
}

使用Embedded类的调用如下所示：

@Embedded
@AttributeOverrides({
        @AttributeOverride(name = "street1", column = @Column(name = "PERSON_STREET_1")),
        @AttributeOverride(name = "street2", column = @Column(name = "PERSON_STREET_2")),
        @AttributeOverride(name = "city", column = @Column(name = "PERSON_CITY")),
        @AttributeOverride(name = "state", column = @Column(name = "PERSON_STATE")),
        @AttributeOverride(name = "zip", column = @Column(name = "PERSON_ZIP")),
        @AttributeOverride(name = "phone", column = @Column(name = "SOLDIER_PHONE")) })
@NotFound(action=NotFoundAction.IGNORE)
public Address getPersonAddress() {
    return personAddress;
}

public void setPersonAddress(Address personAddress) {
    this.personAddress = personAddress;
}

@Embedded
@AttributeOverrides({
        @AttributeOverride(name = "street1", column = @Column(name = "DEPARTMENT_STREET")),
        @AttributeOverride(name = "city", column = @Column(name = "DEPARTMENT_CITY")),
        @AttributeOverride(name = "state", column = @Column(name = "DEPARTMENT_STATE")),
        @AttributeOverride(name = "zip", column = @Column(name = "DEPARTMENT_ZIP")),
        @AttributeOverride(name = "phone", column = @Column(name = "UNIT_PHONE")) })
public Address getDepartmentAddress() {
    return DepartmentAddress;
}

public void setDepartmentAddress(Address DepartmentAddress) {
    this.DepartmentAddress = DepartmentAddress;
}

由于部门地址在数据库中没有要覆盖的Street2，因此似乎爆炸了。

有人可以帮忙吗？

最佳答案

在JPA中，没有概念仅从Embeddable派生属性映射的子集。每次在实体中使用@Embedded时，Embeddable的所有属性都将成为具有其默认映射的实体属性。与您的情况一样，您可以覆盖属性（以及关联），但是不能删除它们。

另外，我还不知道Hibernate中对此有特定于供应商的支持。