在 JPQL 中，如何访问命名参数的属性？

发布于 2024-11-18 13:28:36 字数 408 浏览 1 评论 0原文

我正在使用 Hibernate 3.5.4-Final。

我想将一个实体作为命名查询的参数传递，然后访问该查询中该命名参数的持久属性。我想这样做：

@NamedQuery(name = "hello", query = "SELECT p FROM WorkPackage p WHERE p IN (:workPackage).relatedWorkflows")

问题是在查询接近结束时，

(:workPackage).relatedWorkflows

导致 Hibernate 抛出部署时 QuerySyntaxException。删除括号没有帮助；为了清楚起见，我把它们留在了里面。有什么办法可以解决这个问题，还是我必须以编程方式执行此操作？

原文

I'm using Hibernate 3.5.4-Final.

I want to pass an entity as a parameter of a named query, and then access a persisted property of that named parameter in that query. I want to do this:

@NamedQuery(name = "hello", query = "SELECT p FROM WorkPackage p WHERE p IN (:workPackage).relatedWorkflows")

The problem is near the end of the query, in the

(:workPackage).relatedWorkflows

which causes Hibernate to throw a deploy-time QuerySyntaxException. Remove the parentheses doesn't help; I left them in for clarity. Is there any way around this, or am I going to have to do this programmatically?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

国产ˉ祖宗 2024-11-25 13:28:36

你不能。您必须将属性值本身传递给查询：

@NamedQuery(name = "hello", query = "SELECT p FROM WorkPackage p WHERE p IN (:relatedWorkflows)")

query.setParameterList("relatedWorkflows", workPackage.getRelatedWorkflows());

You can't. You have to pass the property value itself to the query:

@NamedQuery(name = "hello", query = "SELECT p FROM WorkPackage p WHERE p IN (:relatedWorkflows)")

query.setParameterList("relatedWorkflows", workPackage.getRelatedWorkflows());

回复收藏 0 原文

~没有更多了~