db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jakob Braeuchi <jbraeu...@gmx.ch>
Subject Re: PostgreSQL default JDBC fetch size hint
Date Fri, 15 Apr 2005 17:12:37 GMT
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: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message