0 Replies Latest reply on Apr 7, 2004 10:27 AM by Chad Lavy

    Entity taking forever to perform a findAll!

    Chad Lavy Newbie

      Hi,

      I have an entity bean that has a table behind it with only ~1400 records. A normaly command line SQL query on this table takes no time to get all the rows back. JBoss 3.2.3 on Win2000 times out on a 20 minute transaction, however.

      The table has a two-part key and no relationships. JBoss keeps putting out the following query over and over again to get the data:

      SELECT ... FROM ... WHERE (key1 = ? AND key2 = ?) || (key1 = ? AND key2 = ?) ...

      Should I tweek a configuration somewhere?

      Thanks,
      Chad