I need to use read-ahead for a CMR.
So I configured my jbosscmp-jdbc.xml:
<left-join cmr-field="students" eager-load-group="basic"/>
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!!