File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 58
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: 107

Duplicate post - error at query


Thanks,
Tushar (SCJP 1.5)
 
Don't get me started about those stupid light bulbs.
 
subject: org.hibernate.hql.ast.QuerySyntaxError: unexpected token:
 
Similar Threads
SQL to Hibernate HQL conversion error
error in query
Using JSTL Data Displayed In Browser Is Getting Fixed To 24576 Bytes(24 KB)
java.lang.IllegalStateException
Want to convert my code in method