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:

      <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.