hql报错 Path expected for join!
代码
if(hhUserEntity!=null){
String ids="";
Object [] couponIds=(Object[])couponJson.toArray();
if(couponIds!=null&&couponIds.length>0){
for(int i=0;i<couponIds.length;i++){
if(i==0){
ids=ids+"'"+couponIds[i]+"'";
}else{
ids=ids+",'"+couponIds[i]+"'";
}
}
}
String hql="from CouponPublishEntity e left join CouponPoolEntity d where d.pubId=e.pubId and d.owner='"+userId+"' and e.pubid in ("+ids+") ";
List<HhCouponsEntity> list = super.findByQueryString(hql);
System.out.println(list);
if(list!=null&&list.size()>0){
super.deleteAllEntitie(list);
}
报错
[org.hibernate.hql.internal.ast.ErrorCounter] Path expected for join!
[org.hibernate.hql.internal.ast.ErrorCounter] Path expected for join!
Path expected for join!
at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:369)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3645)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3431)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3309)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:706)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:562)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:249)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:184)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:137)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:221)
at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:199)
at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1778)
hql语句哪里错了?