Date criteria isn't getting pushdown with a custom translator in JBEDS

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In