1 Reply Latest reply on Aug 14, 2006 8:08 AM by ingo

    Read-ahead, left-join, oracle problem

    ingo Newbie

      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.