我的原始查询有点复杂,但我要做的是获取实体AlertCondition以及一些其他字段.
+ " SELECT new org.rhq.core.domain.alert.composite.AlertConditionEventCategoryComposite " //
+ " ( " //
+ " ac," //
+ " res.id " //
+ " ) " //
+ " FROM AlertCondition AS ac FETCH ALL PROPERTIES " //
+ " JOIN ac.alertDefinition ad " //
+ " JOIN ad.resource res " //
+ " WHERE " + AlertCondition.RECOVERY_CONDITIONAL_EXPRESSION //
+ " AND ( res.agent.id = :agentId OR :agentId IS NULL ) " //
+ " AND ad.enabled = TRUE " //
+ " AND ad.deleted = FALSE " //
+ " AND ac.category = 'EVENT' " //
+ "ORDER BY ac.id"),//
问题是Hibernate只选择AlertCondition的ID,所以当访问这个对象时,这最终需要N 1选择,而我只想做1.
根据debug,select只获取ID列：
select alertcondi0_.ID as col_0_0_,alertdefin1_.ID as col_1_0_,resource2_.ID as col_2_0_
我想要回来的是* AlertCondition的所有领域.
我在Hibernate下找不到任何办法. JOIN FETCH在这里也没有真正起作用.
另一种方法是选择表格的每一列,我想避免.
解决方法
你可以通过以下方式告诉hibernate获取广告：
JOIN FETCH ac.alertDefinition ad
