I have 2 entity beans, equip and block. There is a 1 * relationship between the 2 beans. If e contains 1 row of the equip bean, and I say e.getBlock.getId, first it load the full row form block, and after it it reads the block id from the row. The problem is that the JBoss makes a new query for every row so it is very slow, because I don't need the whole row just the id.
Please tell me, what can I do. I use Postgre database server and JBoss 3.2.3 Application server.