Writing HQL Query for ManyToOne Association

Hii, I have two entities with bidirectional association.

Project.java

class Project{

    int project_id;

    @OneToMany(mappedBy="project")
    private Set<Users> projectsUsers = new HashSet<Users>();

   开发者_如何学Go //getters and setters and other fields

}

Users.java

class Users{ 

    int id;
    int userId;
    int project_id 

    @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumn(name="project_id") 
    private Project project; 

    //getters and setters and other fields

}

I want to write an HQL query which retrieves the list of projects associated with a particular userId.

I was writing some thing like this which didnt work.

from Project P where P.projectsUsers.userId=1

When trying to execute this I am getting a exception "illegal attempt to dereference collection" can anyone of you please help me in solving the problem?

Thanks in Advance

With Regards

Phani Kumar

First of all, "the list of projects associated with a particular userId" doesn't make sense since you have one-to-many/many-to-one relation so that each user can be associated with no more than one project.

The query to retrieve that project is as follows:

SELECT u.project FROM users u WHERE u.userId = ?