HQL looks for property in wrong class and reports "could not resolve property" ------------------------------------------------------------------------------ Key: HHH-3300 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3300 Project: Hibernate3 Issue Type: Bug Components: query-hql Affects Versions: 3.2.6 Environment: Hibernate 3.2.6.ga, mysql 5.0.37 Reporter: Cristian Bogdan could not resolve property: groupMembers of: projman.Project [SELECT it.project.color AS col1 FROM projman.Deficienta def JOIN def.item it WHERE exists (FROM it.project.participants grp JOIN grp.groupMembers p WHERE p=:principal ) )) ORDER BY it.end] the problem is, groupMembers is not a property of projman.Project, but a bag in projman,Principal. as soon as I replace the it.project.color projection with e.g. it.start (i.e. i don't make any other join with projman.Project), the query works. the original query is actually more complicated but i reduced my test to the above for simplicity. rewriting the query without subqueries is not an option. i paste the relevant (generated) mappings. <hibernate-mapping auto-import="false"> <class name="projman.Project" table="projman_Project_"> <id name="primaryKey" column="Project_"> <generator class="identity"/> </id> <property name="TS_modify" column="TS_modify_"/> <property name="TS_create" column="TS_create_"/> <property name="name"> <column name="name_" length="255"/> </property> <bag name="participants" table="projman_Project__participants_" cascade="all" inverse="false"> <key column="Project_"/> <many-to-many class="projman.Principal" column="Principal_"/> </bag> <many-to-one name="beneficiar" column="beneficiar_" cascade="all" class="projman.Company"/> <many-to-one name="generalDesigner" column="generalDesigner_" cascade="all" class="projman.Compa ny"/> <bag name="signExecution" table="projman_Project__signExecution_" cascade="all" inverse="false"> <key column="Project_"/> <many-to-many class="projman.Company" column="Company_"/> </bag> <property name="color"> <column name="color_" length="6"/> </property> </class> </hibernate-mapping> <hibernate-mapping auto-import="false"> <class name="projman.Principal" table="projman_Principal_"> <id name="primaryKey" column="Principal_"> <generator class="identity"/> </id> <property name="TS_modify" column="TS_modify_"/> <property name="TS_create" column="TS_create_"/> <property name="kind" column="kind_"/> <bag name="groupMembers" table="projman_Principal__groupMembers_" cascade="all" inverse="false"> <key column="Principal_"/> <many-to-many class="projman.Principal" column="Principal__"/> </bag> <property name="displayName"> <column name="displayName_" length="255"/> </property> </class> </hibernate-mapping> <hibernate-mapping auto-import="false"> <class name="projman.Deficienta" table="projman_Deficienta_"> <id name="primaryKey" column="Deficienta_"> <generator class="identity"/> </id> <property name="TS_modify" column="TS_modify_"/> <property name="TS_create" column="TS_create_"/> <many-to-one name="item" column="item_" cascade="all" class="projman.Item"/> <many-to-one name="firma" column="firma_" cascade="all" class="projman.Company"/> <bag name="alteFirme" table="projman_Deficienta__alteFirme_" cascade="all" inverse="false"> <key column="Deficienta_"/> <many-to-many class="projman.Company" column="Company_"/> </bag> <property name="amenda" column="amenda_"/> </class> </hibernate-mapping> <hibernate-mapping auto-import="false"> <class name="projman.Item" table="projman_Item_"> <id name="primaryKey" column="Item_"> <generator class="identity"/> </id> <property name="TS_modify" column="TS_modify_"/> <property name="TS_create" column="TS_create_"/> <many-to-one name="project" column="project_" cascade="all" class="projman.Project"/> <property name="type" column="type_"/> <bag name="toWhom" table="projman_Item__toWhom_" cascade="all" inverse="false"> <key column="Item_"/> <many-to-many class="projman.Principal" column="Principal_"/> </bag> <property name="subject"> <column name="subject_" length="255"/> </property> <property name="description" type="org.makumba.db.hibernate.TextUserType"> <column name="description_" sql-type="longtext"/> </property> <many-to-one name="creator" column="creator_" cascade="all" class="projman.Principal"/> <property name="creationDate" column="creationDate_"/> <property name="start" column="start_"/> <property name="end" column="end_"/> <bag name="events" inverse="true" cascade="none"> <key column="Item_"/> <one-to-many class="projman.Item__events"/> </bag> <bag name="attachments" table="projman_Item__attachments_" cascade="all" inverse="false"> <key column="Item_"/> <many-to-many class="projman.Document" column="Document_"/> </bag> </class> </hibernate-mapping> -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira