JBoss EDS does not push with clause pushed down to Oracle datasource

Solution Verified - Updated -

Issue

I have the following type of query:

with x (select distinct f1, f2, f3, f4, f5 from table1)
select f1 from x
union
select f2 from x
union 
select f3 from x
union 
select f4 from x
union 
select f5 from x
union 

table1 is from an Oracle Source and Oracle supports the with clause.

The issue I have is that EDS is not pushing the whole query down to Oracle. Instead, EDS is pushing down the

select distinct f1, f2, f3 ... f15 from table1

and then performing the unioning in EDS.

When performed on Oracle, a recordset of over 10k records and 15 union queries, as above, the query returns 7k records in under 1 second. When performed via EDS the query is taking over 5 seconds.

Is there anyway to get EDS to push down the entire query?

Environment

  • Red Hat JBoss Data Services (EDS)
    • 5.2.0
    • 5.3.0

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