I have instances where I am doing a read-ahead on-find strategy with a page-size of 4.
For one EJB it does a select for 4 keys: select from table where pk=1 and pk=2 and pk=3 and pk=4.
For another EJB it does: select from table
The example in the CMP book uses a page-size of 4 and the result set has seven rows.
What I need is one query: select from table. There are only 700 rows and I only need the name.
Can anyone shed any light on this behaviour? I am using 3.0.6.
Sorry for possibly not having the proper terms I am not at the office and have access to my code.
That sounds not like a problem about strategy.
SELECT (DISTNCT) name_column
This simple query don't solve your problem?