5 Replies Latest reply on Aug 13, 2002 2:59 AM by Andreas Billmann

    Problems using Page-SIze

    Andreas Billmann Newbie

      Hi,
      I need to use the page-size and I thought setting the page-size to 4 in the standardjbosscmp-jdbc.xml


      ...
      <read-ahead>
      on-load
      <page-size>4</page-size>
      <eager-load-group>*</eager-load-group>
      </read-ahead>
      ..


      will cause the following sql statement for each kind of select;

      SELECT id,name FROM customerejb WHERE (id=1) OR (id=2) OR (id=3) OR (id=4)

      but instead the select statement is

      SELECT id,name FROM customerejb WHERE (id=1) OR (id=2) OR (id=3) OR (id=4) OR (id=5) OR (id=6) OR (id=7) OR (id=8) OR (id=9) OR (id=10) OR (id=11) OR (id=12) OR (id=13) OR (id=14) OR (id=15) OR (id=16) OR (id=17) OR (id=18) OR (id=19) OR (id=20) OR (id=21) OR (id=22) OR (id=23) OR (id=24) OR (id=25) OR (id=26) OR (id=27) OR (id=28) OR (id=29) OR (id=30) OR (id=31) OR (id=32) OR (id=33) OR (id=34) OR (id=35) OR (id=36) OR (id=37) OR (id=38) OR (id=39) OR (id=40) OR (id=41) OR (id=42) OR (id=43) OR (id=44) OR (id=45) OR (id=46) OR (id=47) OR (id=48) OR (id=49) OR (id=50) OR (id=51) OR (id=52) OR (id=53) OR (id=54) OR (id=55) OR (id=56) OR (id=57) OR (id=58) OR (id=59) OR (id=60) OR (id=61) OR (id=62) OR (id=63) OR (id=64) OR (id=65) OR (id=66) OR (id=67) OR (id=68) OR (id=69) OR (id=70) OR (id=71) OR (id=72) OR (id=73) OR (id=74) OR (id=75)

      I thought changing the default section will change the strategy for all the find methods. I hope have not to create an ejb query entry for each query in the application, so that I have twice, one in the jbosscmp-jdbc.xml and one in the ejb-jar.xml

      If the solution is in the JBossCMP Tutorial, (which I have) I didn't find it. The examples on Page 48 only uses the page-size in combination with a query.

      Thx for your time and help.

      Andi