Re: setEndIndexAt

[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