well im trying to write an ejbql statement with group by and having sql clauses for a query by keywords, but it seems that even if hypersonic supports them, ejb-ql doesnt
so my question:
am i wrong and in fact ejb-ql does?
otherwise is there any possibility to override the generated SQL statement with a specific statement which returns the pk of the object i want to return in the ejb-ql? i read on the manual that ejb-ql is overridable with JbossQL, DynamicSQL and something else, but not plain SQL!!!