Bookmark Topic Watch Topic
  • New Topic

org.hibernate.hql.ast.QuerySyntaxError: unexpected token:

 
raj chopra
Ranch Hand
Posts: 64
  • 0
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi All,

executing the below hql query in my web applications results in a error.

query :

String q= "select ORGNAME,VAL from ( select(count(o.organizationId) * 100/ "+
"(select count(b.comp_id.bidId) from SBBid b where b.client.clientId = " +clientId+ " "+
"and b.deletionMark <>1 and b.bid_status_code = 50 )) "+
"as VAL ,org,o.organizationName as ORGNAME "+
" from SBOrganization o , SBMember m,SBBid b ,SBClient c "+
" where "+
"o.deletionMark =0 "+
"and m.deletionMark = 0 "+
"and b.bidStatus.code =50 "+
"and b.member.memberId =m.memberId "+
"and b.client.clientId = "+clientId+
"and c.clientId=b.client.clientId "+
"and c.deletionMark<>1 "+
"and m.organizationId =o.organizationId "+
"group by o.organizationId,o.organizationName "+
"order by 1 desc "+
") "+
"where rownum <=10 ";
error in tomcat CMD prompt:




i tried my best to resolve but had no luck.

kindly help me to shoot this issue.
 
T Mishra
Ranch Hand
Posts: 108
Eclipse IDE Java Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Report post to moderator
Duplicate post - error at query
 
It is sorta covered in the JavaRanch Style Guide.
    Bookmark Topic Watch Topic
  • New Topic