Hibernate Join查询问题
各位老大!我执行下面的语句,先谢拉!
Session session = HibernateUtil.currentSession();
String hql = "select a.id ,a.name,a.age,c.name,s.score From Student as a ";
hql += " left join com.officewyze.bs.Score as s ";
hql += " left join com.officewyze.bs.Course as c";
hql += " where a.id > 1";
List list = session.createQuery(hql).list();
为何总报:
[java] net.sf.hibernate.QueryException: outer or full join must be followed by path expression [select a.id ,a.name,a.age,c.name,s.score From com.officewyze.bs.Student as a left join com.officewyze.bs.Score as s left join com.officewyze.bs.Course as c where a.id > 1]
[java] at net.sf.hibernate.hql.FromParser.token(FromParser.java:166)
hibertnate 的版本是2.1的
所有的相关*.hbm.xml文件都配置好啦
Course.hbm.xml
<hibernate-mapping package="com.officewyze.bs">
<class name="Course" table="COURSE">
<id name="id" column="ID" type="java.lang.Long">
<generator class="native"/>
</id>
<property name="name" column="NAME" type="java.lang.String" />
</class>
</hibernate-mapping>
Student.hbm.xml
<hibernate-mapping package="com.officewyze.bs">
<class name="Student" table="STUDENT">
<id name="id" column="ID" type="java.lang.Long">
<generator class="native"/>
</id>
<property name="name" column="NAME" type="java.lang.String" />
<property name="age" column="AGE" type="java.lang.Long" />
<set name="score">
<key column="sid"></key>
<one-to-many class="com.officewyze.bs.Score" />
</set>
</class>
</hibernate-mapping>
Score.hbm.xml
<hibernate-mapping package="com.officewyze.bs">
<class name="Score" table="SCORE">
<id name="id" column="ID" type="java.lang.Long">
<generator class="native"/>
</id>
<property name="sid" column="SID" type="java.lang.Long" />
<property name="cid" column="CID" type="java.lang.Long" />
<property name="score" column="SCORE" type="java.lang.Long" />
<many-to-one name="course" column="CID" class="Course" insert="false" update="false" />
<many-to-one name="student" column="SID" class="Student" insert="false" update="false" />
</class>
</hibernate-mapping>
问题点数：0、回复次数：6Top
1 楼lifeiqhp（飛哥）回复于 2005-04-04 16:45:37 得分 0
大家帮我瞧瞧Top
2 楼lifeiqhp（飛哥）回复于 2005-04-04 17:27:12 得分 0
upTop
3 楼woderoom（小杨@上海）回复于 2005-04-05 14:54:06 得分 0
a,c,s 之间的关联条件？Top
4 楼xpboy（蜗牛）回复于 2005-04-15 13:39:45 得分 0
mark，我也出现这样的问题啊，谁能解决一下，帮顶Top
5 楼itjourney（IT之旅）回复于 2005-04-15 17:43:18 得分 0
在Student前带上package试试。Top
6 楼indenty（天下之饿）回复于 2005-06-08 08:47:30 得分 0
还是问题,up一下!Top
