jboss-ql and sum()

[eddie07]

Hi,

I am trying to use sum() with the jboss-ql. According to the documentation this should be possible but I couldn't find any examples.
If this is really possible - are there some examples available?
The sql I'd like to execute is something like "select A, sum(B) from mytable where a=1 group by c,d"

Thanks in advance,
Eddie

[aloubyansky]

Sum is allowed to be used only in ejbSelect. And EJBQL query can return only EJB object, CMP field or EJBQL function result. As in the spec. 3.2.4 supports EJBQL-2.1.

[eddie07]

Thanks, this helps me. I did't know that the newest versions are implementing EJB-QL 2.1.
I should read docs more often. :-(

Eddie