我想用JPQL语言编写一个lttl复杂查询,用来访问OneToMany连接表。我得到了QuerySyntaxException: Pan_PanRes没有映射。
查询-
query = "SELECT p FROM Pan p WHERE p.id IN " +
"(SELECT p_id FROM Pan_PanRes p_prs WHERE prs_id IN " +
"(SELECT r.id FROM PRS r where r.pant = :pant))"+
" ORDER BY pr.clD"我尝试在MYSQL中实现这个概念。它工作得很好。所以我知道我没有以正确的方式调用连接表。那么它应该如何命名呢?
我想添加MYSQL语句,它工作得很好-
mysql> select * from pan where id not in
(select pan_id from pan_panres where panres_id in
(select id from panres where pant_id = 3));谢谢..。
发布于 2011-07-26 04:51:59
我自己解决的-
query = "SELECT p FROM Pan p WHERE p.id IN " +
"(SELECT p.id FROM p.panRes prs WHERE id IN " +
"(SELECT r.id FROM PanRes r where r.pant = :pant))"+
" ORDER BY pr.clD"其中,panRes是我在Pan类中使用的oneToMany变量名。
https://stackoverflow.com/questions/6810449
复制相似问题