[odb-users] scrollable cursors

Boris Kolpackov boris at codesynthesis.com
Wed Jun 12 09:15:39 EDT 2013


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



More information about the odb-users mailing list