fetch only the size of a collection (one-to-many)

iconst_0 · **Joined:** Mon Aug 08, 2005 4:53 pm **Posts:** 3

Is there a way of fetching only the size of a collection in a one to many association? For example: I have UserPojo with a collection of FonePojo. Can I use lazy for the one-to-many association and retrieve only the count of FonePojo without loading all related objects?

For example:
load(userPojo);
userPojo.getfones.size(); //retrieves the number of items but does not initialize the collection. is this possible?

Thanks!

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Lots of ways of doing that. This one is from the ref docs, section 14.15, "Tips & Tricks":

Code:

You can find the size of a collection without initializing it:

( (Integer) session.iterate("select count(*) from ....").next() ).intValue();