Hi,

I would like to know which is the recommended way of fetching query results.

Session s = getSession();

List list =
s.find("from User u where u.name=?", userName, Hibernate.STRING);

return list.iterator();

or

Query q = s.createQuery("from User u where u.name= :userName");
q.setString("userName", userName);
return q.iterate();


From a performance point of view is there are there any overheads between both ways?

Thanks,
Jeelani

there is no real concrete difference between both solutions

be carefull with .iterate().... prefer .list() if you aren't using second level cache

Thanks for the reply Anthony.

Jeelani

I could find the detailed answer for my question in Hibernate In Action, chapter -7 page 245. This follows the one said by Anthony.

Thanks,
Jeelani