Mike Writes:

The biggest problem I have with almost all frameworks is the findAll() curse that actually ends up loading too many objects. You have the EJB approach (findAll() just returns primary keys, and then the objects are lazy loaded), or the OFBiz approach (findAll() loads the whole record set in a single query) - but ne'er the twain do meet. - rebelutionary

I hate to sound like a broken record, but hibernate allows both approaches. sess.find() will return you a List of pre-loaded objects, while sess.iterate() returns you an Iterator that will lazily load each object when you call next().