Bonjour,
j'utilise ibatis pour exécuter mes requêtes .Quand je lance ma requête, j'ai cette erreur :
--- The error occurred while applying a parameter map.
--- Check the AnsweredEmail.EmailsRepondusCount-InlineParameterMap.
--- Check the parameter mapping for the 'startDate' property.
--- Cause: java.sql.SQLException: Index de colonne non valide
Caused by: java.sql.SQLException: Index de colonne non valide
Voici ma requête :
SELECT DISTINCT REQ.REQUESTEMAILBOX, Count(*) AS NBREQUETES, REGEXP_SUBSTR(ACCOUNTGROUPLABELS.LABEL,'([^[:blank:]]+)') AS CRCM
FROM TMI.REQUEST REQ, TMI.REQUESTSTATEVENT RSE, TMI.STATEVENT SE, TMI.REQUESTSTATEVENTEX RSEX, TMI.ACCOUNTGROUPLABELS AGL
where
SE.EVENTDATE BETWEEN #startDate# and #endDate# AND
REQ.REQUESTID = RSE.REQUESTID AND
RSE.REQUESTEVENTKIND = 17 AND
RSE.STATEVENTID = SE.STATEVENTID AND
RSE.STATEVENTID = RSEX.STATEVENTEX1 AND
RSE.ACCGROUPID = AGL.ACCOUNTGROUPID AND
AGL.LOCALE like '%fr%' AND
RSEX.EXTYPE = 2
GROUP BY REQ.REQUESTEMAILBOX, REGEXP_SUBSTR(AGL.LABEL,'([^[:blank:]]+)')
Order by REGEXP_SUBSTR(AGL.LABEL,'([^[:blank:]]+)'),REQ.REQUESTEMAILBOX
D'où vient l'erreur ?
Partager