日期:2014-05-18 浏览次数:20682 次
String queryString = "select a.id,a.authority.id,a.name,a.description,b.id,b.name from Authority a left outer join Authority b where a.authority.id = b.id and a.authority.id is not null";
803 ERROR [org.hibernate.hql.PARSER] (http--127.0.0.1-8080-1) Path expected for join!
18:31:30,806 ERROR [org.hibernate.hql.PARSER] (http--127.0.0.1-8080-1) Invalid path: 'b.id'
18:31:30,808 ERROR [org.hibernate.hql.PARSER] (http--127.0.0.1-8080-1) Invalid path: 'b.id'
18:31:30,809 ERROR [org.hibernate.hql.PARSER] (http--127.0.0.1-8080-1) right-hand operand of a binary operator was null
18:31:30,809 ERROR [org.hibernate.hql.PARSER] (http--127.0.0.1-8080-1) <AST>:0:0: unexpected end of subtree
18:31:30,810 ERROR [dao.AuthorityDAO] (http--127.0.0.1-8080-1) find all failed: org.hibernate.hql.ast.QuerySyntaxException: Path expected for join! [select a.id,a.authority.id,a.name,a.description,b.id,b.name from pojo.Authority a left outer join Authority b where a.authority.id = b.id and a.authority.id is not null]
select a.id,a.parentRightID,a.name,b.id,b.name from [wgzxdms].[dbo].[authority] a left join [wgzxdms].[dbo].[authority] b
on a.parentRightID = b.id