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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content