That looks like a report query, is it? Are you trying to build objects out of the result set, or just get scalars? If it's just a report, convert it to an sql-query and all will be well.

Hi thanks 4 ur support but it is not a report query... this query is generated at run time... actually we we have made a query parser in which user can give select attributes, group by attributes, where clause, order by attributes... so we are forming a HQL query which is converted to the underlying database, right now we are using MSSQL but it can mysql also, it can be lotus also... we do not know what the query will be.. so no question arises of making a sql query.....

U plz assist me that how can we stop hibernate from replacing our aliases... we want hibernate to use our alias and not to reproduce it's own

second even if hibernate is replacing our alias then it must replace all the occurences of our alias , not just at one place

third there is an operator "TOP" in MS sql, which is used when we apply ORDER BY in a sub query, without this, order by cannot be applied in a sub query. This operator gives the n top values of the sub query. is there any such operator in HQL also... plz remember i m making queries at run time

If you want to generate the report on the fly, Criteria would be the first choice. Building your own query parser is just reinventing the wheel.

Even if it's generated on the fly, that doesn't mean that it's not a report query. The important characteristic of a report query is that all you're interested in is the returned result set, you don't care if it comes back as POJO entities or JDBC result sets. It may be that an sql-query is good enough in this case, and it will certainly be faster (as no entity objects have to be created).

Finally, wrt your main question: I don't think that you can do this in plain HQL. "select x as y" is not a valid HQL structure, as far as I'm aware. It's certainly not in the refdocs.

Thanks ... but "criteria" will not solve our problem.... we have build a query parser which cab handle very complex queries, such queries can not be handled by using criteria.... not at all we have tried a lot but we were not able to shape our work in "criteria"


Now u plz help me and tell me how can we give an alias to a sub query in select list and we have to use that alias in the order by clause... this is my main problem... bec hibernate replaces my alias at one place and not at another

My query is

SELECT (SELECT SUM(_0_ServiceCharge_0_service.chargeAmount) FROM Service AS _0_service , ServiceCharge AS _0_ServiceCharge_0_service WHERE _transportService_Challan = _0_service AND _0_service = _0_ServiceCharge_0_service.service) AS _sqry1 FROM Challan AS _Challan LEFT OUTER JOIN _Challan.transportService AS _transportService_Challan ORDER BY _sqry1

May be I am wrong in expressing aliases, kindly assist.... now i look towards u with a grt hope that u will solve my problem

From my previous post:

It

Cannot

Be

Done.


Sort it in memory, or use SQL. HQL will not do it.