Quarkus 3+Hibernate Reactive中Panache.project()投影失效问题求助

错误信息 #

java.lang.IllegalStateException: Could not determine appropriate instantiation strategy - no matching constructor found and one or more arguments did not define alias for bean-injection
at org.hibernate.sql.results.graph.instantiation.internal.DynamicInstantiationResultImpl.resolveAssembler(DynamicInstantiationResultImpl.java:197)
at org.hibernate.sql.results.graph.instantiation.internal.DynamicInstantiationResultImpl.createResultAssembler(DynamicInstantiationResultImpl.java:106)

相关代码 #

实体类 #

@Entity
@Table(name = "company")
public class CompanyEntity extends PanacheEntity {
    private String name;
    private String address;

    @OneToMany(mappedBy = "company", targetEntity = DepartmentEntity.class, 
               cascade = CascadeType.ALL, fetch = FetchType.EAGER,
               orphanRemoval = true)
    private List<DepartmentEntity> departments = new ArrayList<>();

    // getters and setters omitted for brevity
}

@Entity
@Table(name = "department")
public class DepartmentEntity extends PanacheEntity {
    private String name;
    private String description;

    @JsonIgnore
    @ManyToOne(fetch = FetchType.LAZY)
    private CompanyEntity company;

    // getters and setters omitted for brevity
}

DTO类 #

public class CompanyProjection {
    private String name;
    private List<DepartmentProjection> departments;

    public CompanyProjection(String name, List<DepartmentProjection> departments) {
        this.name = name;
        this.departments = departments;
    }

    // getters and setters omitted for brevity
}

public class DepartmentProjection {
    private String description;

    public DepartmentProjection(String description) {
        this.description = description;
    }

    // getters and setters omitted for brevity
}

仓库方法 #

@ApplicationScoped
public class CompanyRepository implements PanacheRepository<CompanyEntity> {

    // ...

    @WithSession
    public Uni<List<CompanyProjection>> getCompanyProjections() {
        return findAll().project(CompanyProjection.class).list();
    }
}

解决方案 #

原因分析 #

Panache的project()方法默认依赖Hibernate的动态实例化机制，无法自动识别嵌套集合类型的投影（比如CompanyProjection中的List<DepartmentProjection>），导致无法匹配构造函数参数，抛出异常。

方案一：使用JPQL显式指定投影构造 #

通过编写JPQL查询，明确调用DTO的构造函数，包括嵌套的DepartmentProjection，让Hibernate能正确映射参数：

@ApplicationScoped
public class CompanyRepository implements PanacheRepository<CompanyEntity> {

    @WithSession
    public Uni<List<CompanyProjection>> getCompanyProjections() {
        String jpql = "SELECT new your.package.CompanyProjection(" +
                      "c.name, " +
                      "(SELECT new your.package.DepartmentProjection(d.description) FROM c.departments d)) " +
                      "FROM CompanyEntity c";
        return find(jpql).list();
    }
}

注意替换your.package为实际的DTO包路径，这种方式在数据库层面完成投影，只查询需要的字段，性能更优。

方案二：手动实现投影（流式映射） #

如果JPQL的嵌套投影写法有局限，可以先查询完整实体，再通过流式操作手动映射为DTO：

@ApplicationScoped
public class CompanyRepository implements PanacheRepository<CompanyEntity> {

    @WithSession
    public Uni<List<CompanyProjection>> getCompanyProjections() {
        return findAll().list()
                .map(companies -> companies.stream()
                        .map(company -> new CompanyProjection(
                                company.getName(),
                                company.getDepartments().stream()
                                        .map(dept -> new DepartmentProjection(dept.getDescription()))
                                        .collect(Collectors.toList())
                        ))
                        .collect(Collectors.toList())
                );
    }
}

这种方式更灵活，适合复杂的投影逻辑，但会加载完整的实体对象，需要权衡性能需求。

内容的提问来源于stack exchange，提问作者user21684014