HQL-query help

larslars9999 · **Joined:** Wed Jul 23, 2008 2:50 am **Posts:** 16

if i have follow lines in my java and using HQL,

Session session = HibernateUtil.beginTransaction();
String hql="from User where Name = 'martin' ";
Query query = session.createQuery(hql);
Object o = query.uniqueResult();

And if i have two user with name martin, how can i get/print the result?
Thanks Lars

hlfsousa · **Posted:** Tue Jul 29, 2008 8:57 am

1) check the javadocs, you have the "list()" method, which returns the result of the query as a List.

2) Property names begin with lowercase

Regards,

Henrique

Cameron McKenzie · **Posted:** Wed Jul 30, 2008 7:58 am

Indeed, uniqueResult expects only one result to be returned, so essentially, you use this with a unique query or a query against a primary key, typically.

http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=08masteringhqlandnamedqueries

For potential multiple results, you can call the list or iterate method, which will return a collection you can then loop over at your leisure.

Here's an example of a non-unique query:

Code:

Session session = HibernateUtil.beginTransaction();
String hql;
hql= "from User as u GROUP BY u.id HAVING u.id > 4)";
Query query = session.createQuery(hql);
List users = query.list();
for (int i = 0; i < users.size(); i++) {
  User user = (User) users.get(i);
  System.out.println("Hello World");
  System.out.println(user.getLoginName());
}
HibernateUtil.commitTransaction();

http://jpa.ezhibernate.com/Javacode/lea ... medqueries