This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
My project deals with hibernate,springs,struts.
The below i present you the error i am getting in the web-appliation while executing a new query i coded for some changes in application.The query works fine when executed in database(oracle) according to the table namespaces etc. I believe it had something to to with hql format for the query i had written.
expecting OPEN, found 'FROM' near line 1, column 23 [SELECT ORGNAME,COUNT FROM (SELECT (count(o.organizationId)*100//(select count(bidId) from bid where clientId =166and deletionMark <>1 and bidStatus.code = 50 )) as COUNT , o.organizationId as org ,o.organizationName as ORGNAMEFROM SBOrganization o , com.syntel.sb.appl.bo.client.SBMember m,com.syntel.sb.appl.bo.vendor.SBBid b ,com.syntel.sb.appl.bo.client.SBClient c WHERE o.deletionMark =0 and m.deletionMark = 0 and b.bidStatus.code=50 and b.memberId =m.memberId and b.clientId =166 and c.clientId=b.clientId and c.deletionMark<>1 and m.organizationId =o.organizationId GROUP by o.organizationId ,o.organizationName ORDER by 1 DESC ) WHERE rownum <=10