Hi, maybe this can point you to a solution:
<sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl"> <attribute attribute-name="grabSize" attribute-value="10"/> </sequence-manager> You can use it in the <connection-pool> in repository.xml. I think you'll find more explanations on thin in the docs. Regards, Max > -----Urspr�ngliche Nachricht----- > Von: Max Vesely [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 27. Februar 2003 04:27 > An: [EMAIL PROTECTED] > Betreff: Limiting a number of rows returned > > > 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. > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
