如何使用Hibernate创建与现有对象的复合关键对象

Question

假设我有以下数据库模式

CREATE TABLE employee(
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    hrid VARCHAR (50)
);
CREATE TABLE territory(
    id BIGINT PRIMARY KEY,
    name varchar (50)
);
CREATE TABLE transcode(
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    code VARCHAR (10) NOT NULL
);
create table employee_territory_function(
  employee_id BIGINT NOT NULL,
  territory_id BIGINT NOT NULL,
  transcode_id BIGINT NOT NULL,
  PRIMARY KEY (employee_id,territory_id),
  CONSTRAINT employeeref FOREIGN KEY (employee_id) REFERENCES employee (id),
  CONSTRAINT territoryref FOREIGN KEY (territory_id) REFERENCES territory (id) ,
  CONSTRAINT transcoderef FOREIGN KEY (transcode_id) REFERENCES transcode (id)
);

现在我有了以下JPA映射实体

雇员实体

@Entity
public class Employee implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private long id;
    private String name;
    private String hrid;
    @OneToMany(fetch = FetchType.LAZY, mappedBy = "employee", cascade = CascadeType.ALL)
    private Set<EmployeeTerritoryFunction> employeeTerritoryFunctionList = new HashSet<>();
    //getters and setters
}

领土实体：

@Entity
public class Territory implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private long id;
    private String name;

    // getters and setters for all field

}

转码实体：

@Entity
public class Territory implements Serializable {
    @Id
    private long id;
    private String name;
    //getters and setters
}

EmployeeTerritoryFunction实体（复合键表）

@Entity
@IdClass(value = EmployeeTerritoryFunctionPK.class)
public class EmployeeTerritoryFunction implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @ManyToOne
    private Employee employee;

    @Id
    @ManyToOne
    private Territory territory;

    @ManyToOne
    @JoinColumn(name = "transcode_id", referencedColumnName = "id")
    private Transcode transcode;
    //getters and setters
}

EmployeeTerrityFunction pk

public class EmployeeTerritoryFunctionPK implements Serializable {
    private static final long serialVersionUID = 1L;

    private Long employee;
    private Long territory;
    //getters and setters, no args constructor, equals and hashcode
}

以下样本插入

Employee employee = this.employeeRepository.findByHrid("111");
        if (employee == null) {
            employee = new Employee();
            employee.setName("Marie");
            employee.setHrid("333");
        }

        Territory territory = new Territory();
        territory.setId(2L);
        territory.setName("T2");

        Territory territory2 = new Territory();
        territory2.setId(3L);
        territory2.setName("T3");


        Transcode transcode = this.transcodeRepository.findByCode("ASC");
        Transcode transcode2 = this.transcodeRepository.findByCode("CC");


        EmployeeTerritoryFunction employeeTerritoryFunction1 = new EmployeeTerritoryFunction();

        employeeTerritoryFunction1.setTranscode(transcode);
        employeeTerritoryFunction1.setTerritory(territory);
        employeeTerritoryFunction1.setEmployee(employee);
        employee.getEmployeeTerritoryFunctionList().add(employeeTerritoryFunction1);

        EmployeeTerritoryFunction employeeTerritoryFunction2 = new EmployeeTerritoryFunction();
        employeeTerritoryFunction2.setTranscode(transcode2);
        employeeTerritoryFunction2.setTerritory(territory2);
        employeeTerritoryFunction2.setEmployee(employee);
        employee.getEmployeeTerritoryFunctionList().add(employeeTerritoryFunction2);

        employeeRepository.save(employee);

当我运行上面的代码只有新对象，我没有问题，因为Hibernate自动插入员工，领土和列表employee_territory_function但当我第一次删除所有现有的领土，employee_territory_function并尝试插入使用现有的员工，Hibernate是不能自动插入或更新雇员，自动插入在领土，employee_territory_function。下面的错误

Caused by: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: com.example.demo.Employee.employeeTerritoryFunctionList, could not initialize proxy - no Session

当我将oneToMany fetch类型替换为EAGER时，我得到了以下错误

Caused by: javax.persistence.EntityNotFoundException: Unable to find com.example.demo.Territory with id 3

Hibernate尝试查询区域表，但我不这样做，因为我删除了区域和员工区域功能表上的所有数据，只有员工存量数据没有删除。

请问怎么修理？

Answer 1

EmployeeTerrityFunction和EmployeeTerrityFunctionPK这两个类中的字段的名称应该完全相同，并且具有您没有的相同类型。试着这样做：

@Entity
@IdClass(EmployeeTerritoryFunctionPK.class)
public class EmployeeTerritoryFunction implements Serializable {

    @Id
    @ManyToOne
    private Employee employee;

    @Id
    @ManyToOne
    private Territory territory;
}

public class EmployeeTerritoryFunctionPK implements Serializable {
    private Employee employee;
    private Territory territory;

    public int hashCode() { //TODO }
    public boolean equals(Object obj) { //TODO }

}