wood burning stoves*
The moose likes Object Relational Mapping and the fly likes org.hibernate.hql.ast.QuerySyntaxError: unexpected token: Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Reply locked New topic
Author

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

raj chopra
Ranch Hand

Joined: Apr 09, 2012
Posts: 60
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.

Reagrds,
raj chopra
T Mishra
Ranch Hand

Joined: Apr 04, 2006
Posts: 108

Duplicate post - error at query


Thanks,
Tushar (SCJP 1.5)
 
Consider Paul's rocket mass heater.
 
subject: org.hibernate.hql.ast.QuerySyntaxError: unexpected token: