JPA Hibernate命名查询中的错误
问题描述:
此NamedQuery有什么问题?没有对Hibernate的5工作,但在工作的OpenJPA 1.2.2JPA Hibernate命名查询中的错误
@NamedQuery(name = "Dic_listDByVal", query = "SELECT d FROM Dict d "
+ " WHERE d.memory = m.memory and d.dic = :dic and (m.value LIKE :value)"
+ " ORDER BY d.sortOrder")
答
我想你还没有定义m(in m.memory)
这里,这意味着你必须已经错过了JOIN
条款
+0
是的,缺少m,应该看起来像: @NamedQuery(name =“Dic_listDByVal”,query =“SELECT d FROM Dict d,Mem m” +“WHERE d.memory = m.memory and d.dic =:dic和(m.value LIKE:value)“ +”ORDER BY d.sortOrder“) – Wait
什么是'这里M''m.memory '? –