The following read-ahead setting in jbosscmp-jdbc.xml are ignored. A query finds 27 orders and the entity bean generates a SELECT statement containing 27 ored PK like this:
SELECT <all fields> WHERE (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?) OR (ORDERID=?)
the deployed jbosscmp-jdbc.xml file starts like this:
<jbosscmp-jdbc>
java:/OracleDS
<datasource-mapping>Oracle8</datasource-mapping>
<read-ahead>
on-load
<page-size>255</page-size>
<eager-load-group>*</eager-load-group>
</read-ahead>
more xml ...
I also tried a "none" strategy, but the container still reads all the orders in the same SELECT.
<read-ahead>
none
</read-ahead>
Is this normal? Can I control the size of the selects with a read-ahead setting or another setting? The page-size seems to be frozen at 255.
Philippe
