Is it not possible do use any arithmetic expressions in the select clause of hql? Here is an example from my current project where this would be useful:



Mike

Not in hibernate 2.x but in the future yes at some point for Hibernate 3.x . This issue is one of the reasons we went to a AST based parser. Makes this easier to support.

Thanks for the quick reply David. Do you know if there is currently an issue in JIRA for arithmetic in the select clause? I noticed a few days ago Gavin was soliciting enhancements for the new AST parser.

Mike

Its a given that it will be supported but I suppose it should be documented anyway. I have not kept upto date with what is going on with the parser or requests for it in JIRA. You should have a look. I do know some work has been done but I don't know what state it is in at this point.

One last question. I'm kind of new to Hibernate, do you know if this is possible to use expressions in select clause if I use Criteria?

In general the Criteria API represents a subset of HQLs functionality (though its getting much closer now in Hibernate 3.x).

See this for more info [H3]
http://www.hibernate.org/hib_docs/v3/reference/en/html/querycriteria.html

Mike,
For you example try next (for now) :

- create formula property for transaction.quantity * transaction.cost (for instance property qty)

- now query is

select sum(qty) ...

regards