[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - 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 :)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4052950#4052950

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4052950