Houssam Badri
Houssam Badri

Reputation: 2509

Self-Refering in JPA Entity with Spring boot and myibatis

I have run that script once:

DROP TABLE IF EXISTS COMMITTEE;
CREATE TABLE COMMITTEE(
    CODE NUMBER PRIMARY KEY,
    NAME VARCHAR2(100),
    P_CODE NUMBER,
    CONSTRAINT P_CODE_FK FOREIGN KEY (P_CODE) REFERENCES COMMITTEE(CODE) 
);

Insert into COMMITTEE(CODE, NAME, P_CODE) VALUES(1, 'Parent 1', NULL);
Insert into COMMITTEE(CODE, NAME, P_CODE) VALUES(2, 'Parent 2', NULL);
Insert into COMMITTEE(CODE, NAME, P_CODE) VALUES(3, 'Parent 3', NULL);
Insert into COMMITTEE(CODE, NAME, P_CODE) VALUES(4, 'Child 1.1', 1);
Insert into COMMITTEE(CODE, NAME, P_CODE) VALUES(5, 'Child 1.2', 1);
Insert into COMMITTEE(CODE, NAME, P_CODE) VALUES(6, 'Child 1.3', 1);
Insert into COMMITTEE(CODE, NAME, P_CODE) VALUES(7, 'Child 3.1', 3);
Insert into COMMITTEE(CODE, NAME, P_CODE) VALUES(8, 'Child 3.2', 3);
Insert into COMMITTEE(CODE, NAME, P_CODE) VALUES(9, 'Child 3.3', 3);
Insert into COMMITTEE(CODE, NAME, P_CODE) VALUES(10, 'Child 3.1.1', 7);

In my mapper I have to query all COMMITTEE and get their CHILDREN.

So I configured my entity as follow:

@Entity
@Table(name = "committee")
public class Committee implements Serializable {

    private static final long serialVersionUID = 18787545L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "code")
    private Long code;

    @Column(name = "name")
    private String name;

    @ManyToOne(cascade = { CascadeType.ALL })
    @JoinColumn(name = "p_code", referencedColumnName = "code")
    private Committee parent = null;

    @OneToMany(fetch = FetchType.EAGER, cascade = CascadeType.ALL, mappedBy = "parent")
    private Set<Committee> children = new HashSet<>(0);

    public Committee() {
    }

    public Committee(Long code, String name, Long p_code) {
        this.code = code;
        this.name = name;
        // this.p_code = p_code;
    }

    public long getCode() {
        return code;
    }

    public void setCode(long code) {
        this.code = code;
    }

    public String getName() {
        return name;
    }

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

    /*
     * public Long getP_code() { return p_code; }
     * 
     * public void setP_code(Long p_code) { this.p_code = p_code; }
     */

    public Set<Committee> getChildren() {
        System.out.println("getChildren called");
        return children;
    }

    public void setChildren(Set<Committee> children) {
        System.out.println("setChildren called");
        this.children = children;
    }

    public Committee getParent() {
        return parent;
    }

    public void setParent(Committee parent) {
        this.parent = parent;
    }

}

But I always get empty list from getChildren().

Am I missing something in my entity or in MyIbatis configuration?

UPDATE:

Based on the answer of @Hadi and on the link here of official documentation, changed the entity.

UPDATE 2:

Here is the code of mapper:

@Mapper
public interface CommitteeMapper {

    @Select("SELECT * FROM COMMITTEE")
    Set<Committee> getParents();

    //Some other staff
}

Upvotes: 0

Views: 43

Answers (1)

Hadi
Hadi

Reputation: 17299

Try change to this

@ManyToOne(cascade={CascadeType.ALL})
@JoinColumn(name = "p_code", referencedColumnName = "code") 
private Committee committee = null;

@OneToMany(fetch = FetchType.EAGER, cascade = CascadeType.ALL,mappedBy="committee")
private Set<Committee> children = new HashSet<>(0);

Upvotes: 1

Related Questions