org.hibernate.hql.ast.QuerySyntaxException: Invalid path: 'b.id'

[kk_lucky]

- Invalid path: 'b.id'
- right-hand operand of a binary operator was null
- <AST>: unexpected end of subtree
- Count records failed!Exception:Invalid path: 'b.id' [select count(*) from com.com.omc.Repeater r where r.btsId=b.id and b.id is not null) as rptNum,(select count(r.repeaterId) from com.com.omc.Repeater r where r.btsId=b.id and b.id is not null and r.devModel.rptType.name like '%干放%') as gfNum, (select count(r.repeaterId) from com.com.omc.Repeater r where r.btsId=b.id and b.id is not null and r.devModel.rptType.name not like '%干放%') as reNum, b.region.city.name as cityName) from com.com.omc.Bts b where b.id>0]
org.hibernate.hql.ast.QuerySyntaxException: Invalid path: 'b.id' [select count(*) from com.com.omc.Repeater r where r.btsId=b.id and b.id is not null) as rptNum,(select count(r.repeaterId) from com.com.omc.Repeater r where r.btsId=b.id and b.id is not null and r.devModel.rptType.name like '%干放%') as gfNum, (select count(r.repeaterId) from com.com.omc.Repeater r where r.btsId=b.id and b.id is not null and r.devModel.rptType.name not like '%干放%') as reNum, b.region.city.name as cityName) from com.com.omc.Bts b where b.id>0]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:258)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650)
at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342)
at $Proxy0.createQuery(Unknown Source)
at com.com.common.hibernate.DelegatingSession.createQuery(DelegatingSession.java:112)
at com.com.omc.web.helper.AbstractHelper.getListAndCountAndCommitImmediately(AbstractHelper.java:1474)
at com.com.omc.web.helper.BtsHelper.getList(BtsHelper.java:239)
at com.com.omc.web.home.BtsHome.getList(BtsHome.java:131)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:2155)
at org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1323)
at org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:762)
at org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:837)
at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:426)
at org.apache.struts.taglib.TagUtils.lookup(TagUtils.java:951)
at org.apache.struts.taglib.bean.DefineTag.doEndTag(DefineTag.java:230)
at org.apache.jsp.jsp.bts.bts_005flist_jsp._jspService(bts_005flist_jsp.java:138)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.com.omc.web.servlet.EncodingFilter.doFilter(EncodingFilter.java:50)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)
- Count records fail!
查询语句在数据库手动查询是没有问题的，但是在java里面调用查询就一直报这样的错误了。请问如何解决？

[kk_lucky]

页面查询语句如下： hql.append(" select new map(b.id as id, "); hql.append("b.name as name, "); hql.append("b.nameZH as nameZH, "); hql.append("b.ci as ci, "); hql.append("b.lac as lac, "); hql.append("b.cellID as cellID, "); hql.append("b.longitude as longitude, "); hql.append("b.latitude as latitude, "); hql.append("b.btstypeId as btstypeId, "); hql.append("b.btsAddress as btsAddress, "); hql.append("b.administrator as administrator, "); hql.append("b.contact as contact, "); hql.append("b.type as type, "); hql.append("b.regionId as regionId, "); hql.append("b.region.name as regionName, "); hql.append("b.btsType.name as typeName, "); hql.append("b.code as code, "); hql.append("b.createTime as createTime, "); hql.append("b.updateTime as updateTime, "); hql.append("b.identify as identify, "); hql.append("b.company as company, "); hql.append("b.city as city, "); hql.append("b.classify as classify, "); hql.append("b.shifen as shifen, "); hql.append("b.zaiShanNum as zaiShanNum, "); hql.append("b.country as country, "); hql.append("b.station.name as stationName, "); hql.append("b.vendor.name as vendorName, "); hql.append("b.vindic.vindicName as vindicName, "); hql.append("b.btsProjectPeriod.periodName as periodName, "); hql.append("b.projectState.stateName as stateName, "); hql.append("(select count(r.repeaterId) from Repeater r where r.btsId=b.id and b.id is not null) as rptNum,"); hql.append("(select count(r.repeaterId) from Repeater r where r.btsId=b.id and b.id is not null and r.devModel.rptType.name like '%干放%') as gfNum, "); hql.append("(select count(r.repeaterId) from Repeater r where r.btsId=b.id and b.id is not null and r.devModel.rptType.name not like '%干放%') as reNum, "); hql.append("b.region.city.name as cityName)"); hql.append(" from Bts b where b.id>0 ");

[妞_]

好长的异常啊！

[wolfofshaolin]

好长的hql 啊， 米看到b 表啊。