we observe a case with JBOSS 3.2.1 and Oracle 9 where we do a findAll on a table with 3500 rows, intending to iterate over all result records. The thread doing it seems to hang indefinitely in the findAll though. It works with smaller numbers of records, say a bunch of 100s (still more analysis going on) but fails at larger numbers. No exception, nothing happens. Just hanging. Doing the same select via JDBC direct into Oracle works fine regardless of #records.
Thus, just in case: is there a known problem around this with this version of JBOSS? Have you observed something like this before?