[odb-users] scrollable cursors

[Boris Kolpackov]

Hi Alexander,

александр вершинин <shekli at list.ru> 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.

Boris