hi martin,
you got me wrong. ojb does not use sql hints such as limit, rownum etc.
the PagingIterator is based on a pure select-statement and cursorable resultset.
jakob
Martin Kal�n schrieb:
Martin Kal�n wrote:
How about adding a fetchSize attribute to the JdbcConnectionDescriptor and perhaps also to the query ?
Good idea.
...also worth noting is Jakob's hint that OJB has a proprietary way of setting start- and endIndex for queries (which will set "fetch size" directly through SQL). This will work for every DB supported by OJB.
The benefit of adding a configurable JDBC fetchSize hint would be that (at least for PostgreSQL) one can limit fetch block size without any programmatic changes.
Regards, Martin
--------------------------------------------------------------------- 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]
