[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2978?page=c... ] James Andrews commented on HHH-2978: ------------------------------------ Test case, tested with Hibernate 2.5.2 GA, JDK 1.5, MySQL 5.0.27 NT ------------------------------------------------------------------------------------------------ DB Schema: ------------------------------------------------------------------------------------------------ CREATE TABLE parentnode ( id INT UNSIGNED NOT NULL, name VARCHAR(45) NOT NULL, CONSTRAINT PRIMARY KEY (id) ) CREATE TABLE indexnode ( id INT UNSIGNED NOT NULL, name VARCHAR(45) NOT NULL, CONSTRAINT PRIMARY KEY (id) ) CREATE TABLE childnode ( id INT UNSIGNED NOT NULL, indexNodeId INT UNSIGNED NOT NULL, value INT UNSIGNED NOT NULL, CONSTRAINT fkChiildNodeParent FOREIGN KEY (id) REFERENCES parentnode (id), CONSTRAINT fkChildNodeIndex FOREIGN KEY (indexNodeId) REFERENCES indexnode (id), CONSTRAINT PRIMARY KEY (id, indexNodeId) ) ------------------------------------------------------------------------------------------------ Java sources: ------------------------------------------------------------------------------------------------ intranet/test/ParentNode.java: ------------------------------------------------------------------------------------------------ package intranet.test; import java.util.Map; public class ParentNode { private Long id; private String name; private Map<IndexNode, Integer> children; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Map<IndexNode, Integer> getChildren() { return children; } public void setChildren(Map<IndexNode, Integer> children) { this.children = children; } } ------------------------------------------------------------------------------------------------ intranet/test/IndexNode.java: ------------------------------------------------------------------------------------------------ package intranet.test; public class IndexNode { private Long id; private String name; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } } ------------------------------------------------------------------------------------------------ Mapping file: Test.hbm.xml ------------------------------------------------------------------------------------------------ <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="intranet.test"> <class name="intranet.test.IndexNode" table="test.indexnode"> <id column="id" type="long" name="id"> <generator class="native" /> </id> <property name="name" type="string" /> </class> <class name="intranet.test.ParentNode" table="test.parentnode"> <id column="id" type="long" name="id"> <generator class="native" /> </id> <property name="name" type="string" /> <map name="children" table="test.childnode"> <key column="id" /> <index-many-to-many class="intranet.test.IndexNode" column="indexNodeId" /> <element column="value" type="int" /> </map> </class> </hibernate-mapping> ------------------------------------------------------------------------------------------------ Failing HQL: ------------------------------------------------------------------------------------------------ Anything that references a property of the index class (IndexNode), such as: select parent, index(child).name, child from ParentNode parent left join parent.children child Stack trace as above for this query. ------------------------------------------------------------------------------------------------ Queries fetching the index itself, rather than a property of it, such as: select parent, index(child), child from ParentNode parent left join parent.children child do actually fetch instances of "IndexNode", and work fine, the problem only occurs when trying to fetch a property of the index instance. -- 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