Hibernate Community • View topic - Page class from Gavin's blog

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Page class from Gavin's blog

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

snpesnpe

Post subject: Page class from Gavin's blog

Posted: Sun Aug 15, 2004 10:51 am

Expert

Joined: Sat Jun 12, 2004 4:49 pm
Posts: 915

Is there any reason for use setFirstResult/setMaxResult via ScrollableResult ?

- setFirstResult/setMaxResult make new query to database (for oracle use rownum and don't work with oracle 8.0 and order by)
- ScrollableResult use same query and cursor in database (oracle and postgresql use this)

regards

Top

gavin

Post subject:

Posted: Sun Aug 15, 2004 10:53 am

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

don't hold cursors open across user interactions

Top

snpesnpe

Post subject:

Posted: Sun Aug 15, 2004 2:30 pm

Expert

Joined: Sat Jun 12, 2004 4:49 pm
Posts: 915

never mind - we open cursor again and select part of rows - it is quicker than select with rownum (for oracle)

for any applications we have hold cursor, too

regards

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum