Springboot JPA 表实体关联自身的问题?报错

                    把你的实体类贴上来啊 jpa  join 是join 字段的  不是表名 
                

                    <p><a target="_blank" rel="nofollow">@yysf</a></p>

实体如下：

@Entity
public class SysDept implements Serializable {
    private static final long serialVersionUID = 1L;
    private long deptId;
    private Long deptPid;
    private String deptName;
    private String deptCode;
    private String deptDesc;

    // getter、setter
}

DeptVo如下：

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

    private String deptPName;
    private SysDept sysDept;

    public DeptVo(String deptPName, SysDept sysDept) {
        this.deptPName = deptPName;
        this.sysDept = sysDept;
    }

    // getter、setter
}

                    <pre><code>public class SysDept implements Serializable {
private static final long serialVersionUID = 1L;
private long deptId;
@Column(insertable = false,updatable = false)
private Long deptPid;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "deptPid")
private SysDept parent;
private String deptName;
private String deptCode;
private String deptDesc;

// getter、setter

}

select com.vo.DeptVo(t2.deptName,t1) from SysDept as t1 le'f't join t1.parent as t2

手写的  没有测试 你试试。

如果要按照你那样写，需要使用原生的sql来实现 。jpa不能那么写