java - HQL 查询抛出 ExecutionException

Question

当我尝试运行 HQL 查询时，出现以下异常:

java.util.concurrent.ExecutionException: javax.ejb.EJBException: 
java.lang.IllegalArgumentException: org.hibernate.QueryException: query specified join 
fetching, but the owner of the fetched association was not present in the select list

这是我正在运行的查询:

SELECT new com.airit.propworks.dto.CompanyContactReportDTO(comp, compStatus.statusDesc) 
FROM CoCompany as comp 
LEFT JOIN FETCH comp.coCompanyCategoriesCompanyNumbers as compCat 
LEFT JOIN FETCH comp.coContactCompanyNumbers as compCont 
LEFT JOIN FETCH comp.coOperatingNamesCompanyNumbers 
LEFT JOIN compCat.categoryFunctionCoCategoryList as compFcn 
LEFT JOIN FETCH compCont.coContactDocumentssCompositeFK1 as contDoc 
LEFT JOIN FETCH compCont.coContactJobssCompositeFK1 as contJob 
LEFT JOIN FETCH compCont.coPhoneNumberssCompositeFK1 
LEFT JOIN FETCH contDoc.documentTypeCoDocumentTypes as docTypes 
LEFT JOIN FETCH contJob.contactFunctionCoContactFunctions as contFcn 
LEFT JOIN comp.companyStatusCoCompanyStatuses as compStatus --this was added by me
WHERE comp.companyNumber = ? ORDER BY comp.companyName

倒数第二行是我添加的，构造函数也是我添加的。直到我添加这些行后，我才开始收到异常。

正如您所看到的，倒数第二行引用 comp.companyStatusCoCompanyStatuses 是一个连接，它返回单个 CoCompanyStatuses 对象，然后我尝试从中获取 statusDesc 字符串并将其传递给构造函数。

我不确定是什么导致了我遇到的异常。你们看到什么了吗？

Answer 1

有一个 opened bug用于将select new与join fetch结合使用。

由于问题出在添加的 select new 上，因此您可以将检索与构造 CompanyContactReportDTO 分开。