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.