带Hibernate的Optaplanner-一些DRL规则不起作用

Question

我正在使用Optaplanner申请员工排班。没有毅力，一切都很好。现在，我想添加Hibernate集成。我想从MySQL数据库中获取信息，并将其用作时间表输入。

在数据库中，我有位置和技能表。

员工数据、时隙和工作分配现在已在应用程序中硬编码。

我的域类，技能：

import javax.persistence.*;

@Entity
@Table(name = "SKILL")
public class Skill {

    private long skillId;
    private String name;

    public Skill(String name) {
        this.name = name;
    }

    public Skill() {}

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "SKILL_ID")
    public long getSkillId() {
        return this.skillId;
    }

    public void setSkillId(long skillId) {
        this.skillId = skillId;
    }

    @Column(name = "SKILL_NAME", nullable = false, length=250)
    public String getSkillName() {
        return this.name;
    }

    public void setSkillName(String skillName) {
        this.name = skillName;
    }

    @Override
    public String toString() {
        return name;
    }

}

和职位：

import javax.persistence.*;

@Entity
@Table(name = "POSITION")
public class Position {

    private long positionId;
    private String name;
    private Skill requiredSkill;

    public Position(String name, Skill requiredSkill) {
        this.name = name;
        this.requiredSkill = requiredSkill;
    }

    public Position() {}

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "POSITION_ID")
    public long getPositionId() {
        return this.positionId;
    }

    public void setPositionId(long positionId) {
        this.positionId = positionId;
    }

    @Column(name="POSITION_NAME", nullable=false, length = 100)
    public String getPositionName() {
        return this.name;
    }

    public void setPositionName(String positionName) {
        this.name = positionName;
    }

    @OneToOne(cascade = CascadeType.ALL)
    public Skill getRequiredSkill() {
        return this.requiredSkill;
    }

    public void setRequiredSkill(Skill requiredSkill) {
        this.requiredSkill = requiredSkill;
    }

    @Override
    public String toString() {
        return name;
    }
}

不起作用的规则：

rule "Employee works only on positions with skills he has"
    when
        Assignment(
                employee != null,
                !getEmployee().getSkillSet().contains(getPosition().getRequiredSkill()))
    then
        scoreHolder.addHardConstraintMatch(kcontext, -100);
end

我认为数据库还可以，因为其中的数据以前是用这个应用程序创建的。此外，我还有另一个DRL规则正在运行。我没有收到任何警告/错误-只是在求解过程中没有考虑上述规则。

在解决我得到：

08:40:11.453 [main] DEBUG org.drools.core.common.DefaultAgenda - State was INACTIVE is now FIRING_ALL_RULES
08:40:11.453 [main] DEBUG org.drools.core.common.DefaultAgenda - State was FIRING_ALL_RULES is now HALTING
08:40:11.453 [main] DEBUG org.drools.core.common.DefaultAgenda - State was HALTING is now INACTIVE
08:40:11.453 [main] DEBUG org.optaplanner.core.impl.constructionheuristic.DefaultConstructionHeuristicPhase -     CH step (1), time spent (134), score (-14init/-202hard/0soft), selected move count (7), picked move (domain.Assignment@4d354a3e {null -> domain.Employee@1511d157}).

此外，在乞讨会上，我收到了以下警告：

Failed to add the foreign key constraint. Missing index for constraint 'FKqx7n7alhjrnaw173dc48i47y0' in the referenced table 'skill'

Answer 1

看看我们是如何在optaweb员工名册中添加JPA-hibernate持久性的。

具体来说，对Shift类的乐观锁定提供了一个挑战，我们像这样修复了它。