... but limiting the fetch size by JDBC API supported methods (setFetchSize) implies that i have already loaded ALL records from database, no ?
However, the datas persisted in my DERBY database concern logging. It means that i would have to get thousands of records.
On 2/17/06, Legolas Woodland
<[EMAIL PROTECTED]> wrote:
Sylvain RICHET wrote:Derby sql does not has any facilities for limiting number of rows in select statement.Hi everyone,
In a selection statement, i would like to get blocks of records.
Thus, i need to filter records by a "row number", directly at the SELECT level.
It seems that the way to address a row number is not (SQL) standard.
(different "proprietary" implementations)
In Oracle, there is the "rowid".
In MySQL, the "LIMIT" clause can do it.
In SQL Server, i think there is the "ROW_NUMBER() OVER..."
In DB2 (on AS/400) , there is the "RRN" (Relative Record Number)...
What about Derby database ?
How is it implemented on this server ?
I know i could use
Thanks in advance.
you can just limit the fetch size in JDBC resultSets.
