hql语句没什么问题啊,可一直报这个错。。。。
Caused by: org.hibernate.QueryException: could not resolve property: BrandId of: com.goodbaby.goods.brand.model.CrmBrand [select crmCustomerBrand.brandId,crmCustomerBrand.name,cbs.isFirst from com.goodbaby.customer.model.CrmCustomer cc,com.goodbaby.goods.brand.model.CrmCustomerBrandStation cbs,com.goodbaby.goods.brand.model.CrmBrand crmCustomerBrand where 1=1 and cc.customerId=cbs.customerId and cbs.brandId=crmCustomerBrand.BrandId and cc.customerId='31031339' order by crmCustomerBrand.brandId desc]
at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:67) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:61) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1385) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:302) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:407) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:589) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:264) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:211) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:117) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:113) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:750) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1216) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4041) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3528) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1762) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1690) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1687) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:776) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:577) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:251) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:101) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:80) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650) ~[hibernate-core-3.3.0.SP1.jar:3.3.0.SP1]
at sun.reflect.GeneratedMethodAccessor440.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[?:1.6.0_39]
at java.lang.reflect.Method.invoke(Method.java:597) ~[?:1.6.0_39]
at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1197) ~[spring-hibernate3-2.0.3.jar:2.0.3]
at sun.proxy.$Proxy126.createQuery(Unknown Source) ~[?:?]
at com.goodbaby.core.hibernate.DefaultHibernateTemplate$12.doInHibernate(DefaultHibernateTemplate.java:234) ~[DefaultHibernateTemplate$12.class:?]
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367) ~[spring-hibernate3-2.0.3.jar:2.0.3]
... 96 more