Hi super-boosters
I need to use read-ahead for a CMR.
So I configured my jbosscmp-jdbc.xml:
<read-ahead>
on-find
<page-size>4</page-size>
<eager-load-group>basic</eager-load-group>
<left-join cmr-field="students" eager-load-group="basic"/>
</read-ahead>
So far so good, the created sql is "correct"
select column1,column2...... from a left outer join b.........
The problem is that Oracle not supports this kind of join. I need something like:
select column1,column2...... from a, b where .......
Seems to me as a common problem but I can't find a solution.
Thanks in advance for all comments, I'm kind of stuck here.
Ok, it seems to work in Oracle 9i but not in Oracle 8.1.7.
I need this to work for Oracle 8.1.7!!
Any ideas?