Date criteria isn't getting pushdown with a custom translator in JBEDS
Issue
- We have developed a custom translator to our NoSql datasource. We have defined an access path on the Entity_Model.OperationalException table on systemInstanceId,businessDate and Location. When I execute the below query the business date is not pushdown to the translator and throwing an error. It seems to be a bug in the BETWEEN AND >= <= predicate. When I try for a single business date it works. Can you please advise?
select opEx.sourceSystem SourceSystem
,opEx.systemInstanceId SourceSystemCode
,opEx.businessDate BusinesDate
,opEx.type ExceptionType
,opEx.errorMessage ExceptionDetails
from Entity_Model.OperationalException opEx
WHERE
opEx.systemInstanceId = 'EDS TEST'
--and opEx.businessDate between '2012-02-27' and '2012-04-02'
and opEx.businessDate >= '2012-02-27' and opEx.businessDate <= '2012-04-02'
and opEx.Location = 'TEST'
Environment
- JBoss Enterprise Data Services (JBEDS) 5.2
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.