Hi Ralf, That's what I thought. But it's so easy to use OQL queries while using different database type! Thank you for your answer.
Have a good day. Sylvie. ___________________ CREDI RA Sylvie Palluel [EMAIL PROTECTED] ___________________ > -----Message d'origine----- > De : Ralf Joachim [mailto:[EMAIL PROTECTED] > Envoyé : mercredi 21 septembre 2005 10:32 > À : dev@castor.codehaus.org > Objet : Re: [castor-dev] Multi-column queries > > 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 (Im 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] > ------------------------------------------------- ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
