hibernate：使用条件访问对象内的对象

发布于 2024-10-04 04:57:30 字数 730 浏览 1 评论 0原文

我正在使用条件来获取包含活动用户的通知列表。问题是我收到以下错误：

org.hibernate.QueryException: could not resolve property: user.active of: com.company.Notification

除了检查用户是否处于活动状态之外，我还需要检查通知是否属于我想要的类型。这是我的代码：

session.createCriteria("com.company.Notification")
    .add(Restrictions.or(Restrictions.eq("type", "email"), 
    .add(Restrictions.eq("user.active", true)).list();

通知有一个字段 User user ，而该字段又有一个字段 Boolean active

我正在查看此页面：https://forum.hibernate.org/viewtopic.php?t=948576&highlight=subproperty

但我我仍然不知道如何创建一个访问父对象和子对象中某些内容的标准。

原文

I am using criteria to get a list of notifications that contains users that are active. The problem is that i get the following error:

org.hibernate.QueryException: could not resolve property: user.active of: com.company.Notification

Other then checking that the user is active i need to check that the notification is of a type that i want. Here is my code:

session.createCriteria("com.company.Notification")
    .add(Restrictions.or(Restrictions.eq("type", "email"), 
    .add(Restrictions.eq("user.active", true)).list();

Notification has a field User user which in turn has a field Boolean active

i am looking at this page: https://forum.hibernate.org/viewtopic.php?t=948576&highlight=subproperty

but i am still not groking how to create a criteria that accesses something in the parent object and in child object.

分享到QQ

分享到微博

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

发布评论

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

恋你朝朝暮暮 2024-10-11 04:57:30

试试这个：

session.createCriteria("com.company.Notification")
    .add(Restrictions.or(Restrictions.eq("type", "email")
    .createCriteria("user") // this creates the join on the user table...
    .add(Restrictions.eq("active", true)).list();

希望有帮助...

try this:

session.createCriteria("com.company.Notification")
    .add(Restrictions.or(Restrictions.eq("type", "email")
    .createCriteria("user") // this creates the join on the user table...
    .add(Restrictions.eq("active", true)).list();

hope that helped...

回复收藏 0 原文

~没有更多了~