Hibernate, help me

[Nick15]

I have the classes:

Code:

public class Rol {
    private int id;
    private Set projectMember = new HashSet();
    private String description;
 
    ....getters y setters....
}
 
 
public class ProjectMember {
    private int id;
    private Member member;
    private Project project;
 
 
    ....getters y setters....
}

the xml

Code:

hibernate-mapping>
    <class name="Model.Rol" table="item10.role">
        <id name="id" type="int" column="OID">
            <generator class="native"/>
        </id>
        <property name="description" column="DESCRIPTION"/>
        <set name="projectMember" table="item10.pm_roles">
            <key column="ELT"/>
            <many-to-many class="Model.ProjectMember" column="id_projectmember"/>  
        </set>
    </class>
</hibernate-mapping>

I have the ProjectMember.hbm.xml too
And i try to do a query with HQL:

Query query = session.createQuery("select m FROM Model.Member m, Model.Projec p, Model.Rol r, Model.ProjectMember pMember where r.projectMember.proyecto.id=p.id ");

the red sentence gives me an error. If I use r.projectMember.id works fine but if I use r.projectMember.project.id gives me the error before mentioned.

why?

[roland]

would need to see the Project code and mapping to be sure but maybe Project.id does not exist and/or is not mapped

what exactly is the error you get? got a stackdump?

[JForum4Hari]

Hi Nick15 ,

If you post the error message, it will be more clear.