Re[2]: [odb-users] scrollable cursors

александр вершинин shekli at
Fri Jun 14 03:53:55 EDT 2013


Среда, 12 июня 2013, 15:15 +02:00 от Boris Kolpackov <boris at>:
>Hi Alexander,
>александр вершинин < shekli at > writes:
>> Could you please answer does ODB support scrollable cursors with
>> Postgres like  ScrollableResults in hibernate?
>No, ODB result sets only support forward iteration and the reason
>for this is that scrollable results, in most databases, have very
>poor performance compared to the streaming ones.
>If you are looking for scrollable results in order to support
>pagination, then a better option would be to use the Postgres
>LIMIT and OFFSET clauses. The archives of this mailing list
>have some examples, if you are interested.

александр вершинин

More information about the odb-users mailing list