Hi Sylvie, Castor do not support domain functions and group operations with OQL.
I suggest you to use SQL passthrough statements like: CALL SQL select color, sum(weight) as total, count(*) as quantity from cat_table group by color AS my.package.MyClass You have to implement a result class (e.g. my.package.MyClass) and provide a mapping for it. Regards Ralf SYLVIE PALLUEL schrieb: > Hello, > > > > I have to make statistics on the datas of our application. > > > > Is it possible to use OQL to make this query (I’m still in 0.9.6): > select cat.color, sum(cat.weight), count(cat) from fr.cnam.Cat cat > group by cat.color > > > > And in this case what kind of object will be the result of the execution? > > > > Thanks for your help. > > > > Sylvie. > > ___________________ > > CREDI RA > > Sylvie Palluel > > > > [EMAIL PROTECTED] > > ___________________ > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
