> So I'm missing the limit/offset clauses... I've read
> somewhere (don't ask where, I don't remember), that
> if the database supports LIMIT/OFFSET jboss sends
> these clauses to the database, otherwise does this
> limiting of the resultset itself. Seems that in our
> case JBoss does not know that our postgresql database
> is capable of supporting LIMIT/OFFSET.
The LIMIT/OFFSET support in JBossQL is dumb one that works on all app servers, so it doesn't send the LIMIT/OFFSET to the database. You need to use declared SQL or ejbFind overrides to send uninterpreted SQL to the database.