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
|