Hibernate 查询问题！谁来帮我看看是什么原因！？

[ccsky001]

错误：
/-- Encapsulated exception ------------\
org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: ON near line 1, column 76 [from com.huanda.domain.judge.JudgeProject j LEFT OUTER JOIN WorkTypeView v ON j.workType.id = v.id.workTypeId AND j.workTypeLevel.id = v.id.worktypeLevelId WHERE (v.id.examType like '%2%')]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ON near line 1, column 76 [from com.huanda.domain.judge.JudgeProject j LEFT OUTER JOIN WorkTypeView v ON j.workType.id = v.id.workTypeId AND j.workTypeLevel.id = v.id.worktypeLevelId WHERE (v.id.examType like '%2%')]
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ON near line 1, column 76 [from com.huanda.domain.judge.JudgeProject j LEFT OUTER JOIN WorkTypeView v ON j.workType.id = v.id.workTypeId AND j.workTypeLevel.id = v.id.worktypeLevelId WHERE (v.id.examType like '%2%')]

原查询语句:

from JudgeProject j LEFT OUTER JOIN WorkTypeView v ON j.workType.id = v.id.workTypeId AND  j.workTypeLevel.id = v.id.worktypeLevelId WHERE (v.id.examType like '%2%')

[ccsky001]

-_-!!!!!!!!!!!!

[imA]

from com.huanda.domain.judge.JudgeProject j LEFT OUTER JOIN WorkTypeView v ON j.workType.id = v.id.workTypeId AND j.workTypeLevel.id = v.id.worktypeLevelId WHERE (v.id.examType like '%2%')


红色字体部分是hibernate不支持的字符。


你可以自己写一个例子测试一下，看看hibernate是否支持left join on操作

[www203]

from com.huanda.domain.judge.JudgeProject j LEFT OUTER JOIN WorkTypeView v ON j.workType.id = v.id.workTypeId AND j.workTypeLevel.id = v.id.worktypeLevelId WHERE (v.id.examType like '%2%')


红色字体部分是hibernate不支持的字符。


你可以自己写一个例子测试一下，看看hibernate是否支持left join on操作

[ccsky001]

是不是一定要在XML中配置才能用这种查询啊！？

[Landor2004]

hql不支持LEFT OUTER JOIN WorkTypeView v ON的形式，你换成createSQLQuery吧，或者命名sql查询吧

[zidasine]

只在xml中配过 没试过自己写

[ccsky001]

在xml怎么配谁能给个例子看一下！多谢!马上送分！

[网站推广优化yetaoaiueo]

createSQLQuery

[ccsky001]

马的！配的我累死了,老出错！还是用createSQLQuery吧！
唉...谁叫我是菜鸟呢！