0

Oracle defines the operator (+) for outer joins.

We are trying use JDV as the source of an external product (Business Object) which uses those oracle operators.

We cannot change the way that product generates the queries, and it does use the (+) operator, failing the integration with a JDV underlying database.

Is there a way to parse that outer join notation?

Rafael Coutinho
  • 523
  • 5
  • 11

1 Answers1

0

This was answered on the TEIID support site by Steven Hawkins https://issues.jboss.org/browse/TEIID-4747

It is possible to install a PreParser - https://teiid.gitbooks.io/documents/content/dev/PreParser.html and convert the + to an outer join that JDV will understand.

Rafael Coutinho
  • 523
  • 5
  • 11