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

[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

  • setEndIndexAt matthieu . patou
    • Re: setEndIndexAt Jakob Braeuchi

Reply via email to