Limiting a number of rows returned

[Max Vesely]

Hi,
 
   Does anyone know how to limit a number of rows returned from database
using OJB?  
 
Most of the database engines implement custom keywords to limit a number of
rows for select statement (top, limit, rownum () < .....), OJB Query
interface has methods in it to set EndAt and StartAt indexes as well as the
size of resultset returned but setting them doesn't really help. The
database engine I'm using is HSQLDB.
 
Thank, you in advance.
 
Max.