String hql="select u.portrait,u.nickname,nvl(d.dc,0)+nvl(b.bc,0)" +
"from UserBean u ,(select d.owner.userid,count(id) as dc from DiaryBean d group by owner.userid) d," +
"(select param2 as userid,count(id) bc from BookInfoBean group by param2) b " +
"where d.owner.userid(+)=u.userid and b.userid(+)=u.userid ";后台报错如下:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: select near line 1, column 95 [select u.portrait,u.nickname,nvl(d.dc,0)+nvl(b.bc,0)from com.liusoft.dlog4j.beans.UserBean u ,select d.owner.userid,count(id) as dc from com.liusoft.dlog4j.beans.DiaryBean d group by owner.userid d,(select param2 as userid,count(id) bc from com.liusoft.dlog4j.beans.BookInfoBean group by param2) b where d.owner.userid(+)=u.userid and b.userid(+)=u.userid ]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(Unknown Source)
意思就是from后边的这个(select d.owner.userid,count(id) as dc from DiaryBean d group by owner.userid) d,有问题?
为什么?。
"from UserBean u ,(select d.owner.userid,count(id) as dc from DiaryBean d group by owner.userid) d," +
"(select param2 as userid,count(id) bc from BookInfoBean group by param2) b " +
"where d.owner.userid(+)=u.userid and b.userid(+)=u.userid ";后台报错如下:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: select near line 1, column 95 [select u.portrait,u.nickname,nvl(d.dc,0)+nvl(b.bc,0)from com.liusoft.dlog4j.beans.UserBean u ,select d.owner.userid,count(id) as dc from com.liusoft.dlog4j.beans.DiaryBean d group by owner.userid d,(select param2 as userid,count(id) bc from com.liusoft.dlog4j.beans.BookInfoBean group by param2) b where d.owner.userid(+)=u.userid and b.userid(+)=u.userid ]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(Unknown Source)
意思就是from后边的这个(select d.owner.userid,count(id) as dc from DiaryBean d group by owner.userid) d,有问题?
为什么?。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货