在使用HQL Join查询时报错(org.hibernate.hql.ast.QuerySyntaxException: Path expected for join!).
请大家帮我看下Hibernate的映射文件有什么问题,
TStaff.xml<hibernate-mapping>
<class name="com.hq.hibernate.TStaff" table="t_staff" schema="dbo" catalog="HQOTC">
<many-to-one name="tdepartment" column="id" class="com.hq.hibernate.TDepartment" outer-join="true">
</many-to-one>
</class>
</hibernate-mapping>TDepartment.xml<hibernate-mapping>
<class name="com.hq.hibernate.TDepartment" table="t_Department" schema="dbo" catalog="HQOTC">
<bag name="tstaff">
<key column="ideptId"></key>
<one-to-many class="com.hq.hibernate.TStaff"/>
</bag>
</class>
</hibernate-mapping>
请大家帮我看下Hibernate的映射文件有什么问题,
TStaff.xml<hibernate-mapping>
<class name="com.hq.hibernate.TStaff" table="t_staff" schema="dbo" catalog="HQOTC">
<many-to-one name="tdepartment" column="id" class="com.hq.hibernate.TDepartment" outer-join="true">
</many-to-one>
</class>
</hibernate-mapping>TDepartment.xml<hibernate-mapping>
<class name="com.hq.hibernate.TDepartment" table="t_Department" schema="dbo" catalog="HQOTC">
<bag name="tstaff">
<key column="ideptId"></key>
<one-to-many class="com.hq.hibernate.TStaff"/>
</bag>
</class>
</hibernate-mapping>
<key column="ideptId"> </key>
<one-to-many class="com.hq.hibernate.TStaff"/>
</bag>
bag是什么啊?我记得应该是set吧
<set name="tstaff">
<key column="ideptId"> </key>
<one-to-many class="com.hq.hibernate.TStaff"/>
</set>
还有关联的字段都应该是ideptId吧
<many-to-one name="tdepartment" column="ideptId" class="com.hq.hibernate.TDepartment" outer-join="true">
</many-to-one> 还有就是tdepartment跟你的staff类里面的名称是否对应?看看这几个方面再试试!