How to build HQL query, thats joins subtables marked LAZY, automatically?

I have some entity: public class Album extends GenericAuditedEntity { @OneToMany(fetch = FetchType.LAZY) private Set itemSet = new HashSet(); } And when i run HQL like this: em.createQuery("select a from Album a").getResults() it produses many SQL queries: One for select data from Album's table. Smth like this: select .... from Album_table; And one query for each fetched row, for selecting items. Smth like this: select .... from Item_table iwhere i.Album_id = :Album_id; But when i run em.createQuery(" select a.id, b.id from Album a left join Item i ").getResults() it produses one SQL query. But it's result is list of some parameters, that i need put into the entities manually. How can i build HQL with joins automatically and automatically put the results to the entities? Is it possible?

以上就是How to build HQL query, thats joins subtables marked LAZY, automatically?的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » JavaScript 答疑

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏