Hi,
JBoss 4.0.4, Linux
@NamedNativeQuery(name="nbQuestionnairesParEndroitEtDate", query="SELECT COUNT(*) AS nb, endroit AS e, MONTH(dateeven) AS m, YEAR(dateeven) AS y from questionnaires group by m,y, e order by e,y,m", resultSetMapping="NbQuestionnairesParEndroitEtDateMapping") @SqlResultSetMapping(name="NbQuestionnairesParEndroitEtDateMapping", columns={ @ColumnResult(name="n"), @ColumnResult(name="y"), @ColumnResult(name="m"), @ColumnResult(name="e") })