0 Replies Latest reply on Dec 12, 2003 4:58 PM by rouvi

    JBossCMP documentation for Windows, chapter 6 'Optimized loa

    rouvi Newbie

      Hi,

      We use
      JBoss 3.2.2 build: CVSTag=JBoss_3_2_2 date=200310182216

      I have tried the examples mentioned in the document JBossCMP concerning the chapter 6.

      I have run the test 'ant readahead' concerning the optimized loading with a relationship.
      The document says, that the fields of the gangster table AND the location table should be loaded together (...FROM gangster, location).

      It doesn't work !

      Instead, more than 20 queries are executed :

      1.
      SELECT t0_g.id, t0_g.name, t0_g.nick_name, t0_g.badness, t0_g.id FROM GANGSTER t0_g ORDER BY t0_g.id ASC

      2.
      SELECT id, cell_area, cell_exch, cell_ext, page_area, page_exch, page_ext, email, hangout FROM GANGSTER WHERE (id=?) OR (id=?) OR (id=?) OR (id=?)

      3.
      SELECT city FROM LOCATION WHERE (id=?)
      and the same for each field of the table LOCATION

      ...

      15.
      SELECT id, cell_area, cell_exch, cell_ext, page_area, page_exch, page_ext, email, hangout FROM GANGSTER WHERE (id=?) OR (id=?) OR (id=?) OR (id=?)

      16.
      SELECT city FROM LOCATION WHERE (id=?)
      and the same for each field of the table LOCATION


      Does anyone experience the same problem ? Is it a bug ? Is a newer version of the documentation/example available ?

      Thank you for your help.