[castor-dev] Castor JDO and sql complex query

[Sylvie RAMON]

Hi, 

I would like to do a complex sql query to do stat on a table.

SQL QUERY :
select distinct ssm.libelle, null,null,null,null,null,null,null,null,
count(a.SMIDDERNIERCONTACT),null,null,null
from ABONNE a, sousmotif ssm  
where a.SMIDDERNIERCONTACT is not null and a.SMIDDERNIERCONTACT = ssm.SMID
group by ssm.libelle

I map the result to a general class, wich allow me to do different request on the same 
class ( that 's the reason why there is a lot of null on the reques ): 
In fact, there no table map to this class. 
public class RequeteStat {
        private java.lang.String string1;
        private java.lang.String string2;
        private java.lang.String String3;
        private java.sql.Timestamp timeStamp1;
        private java.sql.Timestamp timeStamp2;
        private java.sql.Timestamp timeStamp3;
        private double double1;
        private double double2;
        private double double3;
        private long long1;
        private long long2;
        private long long3;
        private long long4;
getter 
setter
}

With vajava and jdbc, it works fine.

I don't know how can i do that with castor.

Someone has an idea ??
thanks a lot.
Sylvie

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev