0 Replies Latest reply on Apr 16, 2004 7:31 AM by stscit04

    Executed SQL on findAll()

    stscit04 Newbie

      Hi,

      I have an findAll() query in my entityBean. I select large numbers
      of beans with this method (up to 30k). The bean has an compound
      PK (id (String) + date (Date)). The server.log shows the following
      query:

      Executing SQL: SELECT blz, changeDate, flagDeletion, bankId FROM ShadowBLZ WHERE (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? AND changeDate=?) OR (blz=? ...

      And so on....

      Is there a way to improve this ? I am using Jboss 3.2.2 + MySQL 4

      Thanks in advance

      Stefan