[odb-users] scrollable cursors
boris at codesynthesis.com
Wed Jun 12 09:15:39 EDT 2013
александр вершинин <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.
More information about the odb-users