aspose 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 Java 8 in Action this week in the Java 8 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)
 
I agree. Here's the link: http://aspose.com/file-tools
 
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)
Want to convert my code in method
java.lang.IllegalStateException