Hi all

who know how can i resolve my issue with that querie ? I am using Hibernate 2.1.6 with Oracle 9i

net.sf.hibernate.QueryException: in expected: SELECT [

SELECT SUM(taille)
FROM (
SELECT DISTINCT fichierId, taille
FROM com.test.InstanceParTransfert AS Ipa,
FROM com.test.Fichier AS Fic,
FROM com.test.Transfert AS Tr
WHERE Ipa.comp_id.fichierIdFk = Fic.fichierId
AND Tr.transfertId = Ipa.comp_id.transfertIdFk
AND Ipa.comp_id.transfertIdFk = :transfertId
AND Tr.dateCommande BETWEEN :dateDebut AND :dateFin
GROUP BY fichierId, taille
)
HAVING SUM(taille) >= :taille

]

Thanks in advance

-------
Sebastien