0 Replies Latest reply on Jun 10, 2007 5:05 PM by paoletto

    EJB-QL 2.1 with GROUP BY and HAVING clauses

    paoletto

      Hi

      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!!!

      thanks in advance :)