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.