- 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'
- JBoss Enterprise Data Services (JBEDS) 5.2
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.