Hibernate Community • View topic - How to get the size of a ScrollableResults

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to get the size of a ScrollableResults

Page 1 of 1

[ 5 posts ]

Previous topic | Next topic

Author

Message

cecmaho

Post subject: How to get the size of a ScrollableResults

Posted: Tue Sep 09, 2003 9:34 pm

Beginner

Joined: Tue Aug 26, 2003 11:33 pm
Posts: 38

I want to get the number of objects returned from a Query. I get the query result as the form of a ScrollableResults. But how do I get the number of objects contained in this ScrollableResults ?

Any help is appreciated .

Top

gavin

Post subject:

Posted: Tue Sep 09, 2003 11:42 pm

Hibernate Team

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

Woops. I thought I added the getRowNumber() method ages ago .... but I didn't, apparently :(

Why exactly are you using ScrollableResults for?? This is a very exotic feature. Usually there are better ways.

Top

cecmaho

Post subject: Because I use hibernate 2.0.3 to randomly fetch object

Posted: Wed Sep 10, 2003 2:55 am

Beginner

Joined: Tue Aug 26, 2003 11:33 pm
Posts: 38

With your advice, I'd like to use the index() HQL function to randomly get objects from a query, but that's only implemented in 2.1.X. So I have to use ScrollableResults to gain comparable performance. Now I want to randomly select questions from a huge number of questions out of some query. I need the query result size to generate an random int array, with which to randomly select records.

Any advice ?

Top

gavin

Post subject:

Posted: Wed Sep 10, 2003 3:32 am

Hibernate Team

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

issue a count() query beforehand, thats the only way i know...

Top

cecmaho

Post subject: I'll use count()

Posted: Wed Sep 10, 2003 4:57 am

Beginner

Joined: Tue Aug 26, 2003 11:33 pm
Posts: 38

Thanks!

Top

Page 1 of 1

[ 5 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