You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by ma...@mpsa.com on 2005/10/20 10:24:57 UTC
setEndIndexAt
Hello dear ojb users,
It seems that the function setEndIndexAt() works but not exactly like the
documentation indicate.
To be more explicit :
It is stated that this function :"Set the row at which the query should
stop retrieving results, inclusive" but it doesn't seems to limit the
number of line fetched from the database. It just limit the number of
object created.
Is there an evolution planned to implement for database that support it a
database limitation ? Is there another function that do a fetch limit
directly ?
Cordialement
Matthieu PATOU
DINQ/DSIN/SIDM/VNVO/VOIN
Téléphone 01 30 19 17 91 (29 17 91)
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: setEndIndexAt
Posted by Jakob Braeuchi <jb...@gmx.ch>.
hi mattieu,
setStartIndexAt and setEndIndexAt do currently not affect the generated
sql because this is not a standardized feature of sql and thus is
handled differently by the dbms. some dbms provide a limit-clause.
others use the rownumber, etc.
jakob
matthieu.patou@mpsa.com schrieb:
>
>
>
> Hello dear ojb users,
>
> It seems that the function setEndIndexAt() works but not exactly like the
> documentation indicate.
> To be more explicit :
>
> It is stated that this function :"Set the row at which the query should
> stop retrieving results, inclusive" but it doesn't seems to limit the
> number of line fetched from the database. It just limit the number of
> object created.
>
> Is there an evolution planned to implement for database that support it a
> database limitation ? Is there another function that do a fetch limit
> directly ?
>
> Cordialement
>
> Matthieu PATOU
>
> DINQ/DSIN/SIDM/VNVO/VOIN
> Téléphone 01 30 19 17 91 (29 17 91)
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org