4 Replies Latest reply on Feb 27, 2003 7:12 AM by Uri

    read-ahead settings in jbosscmp-jdbc.xml ignored

    Philippe C Newbie

      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