How to print results NON-iteratively (i.e. 1 result)?

xaeryan · **Joined:** Fri May 04, 2007 3:43 pm **Posts:** 18

Currently, I'm only familiar with the iterative method of looping through all results from an HQL query. This seems like a lot of code if there is only one result; can someone steer me to a better alternative to the following code? Assume that the HQL query will return only 1 result. I want to print the resulting column (ACTIONS):

Code:

// perform query and count the results
      List result = session.createQuery("from Users as user where NAME='"+name+"'").list();
      if (result.size() == 1)
      {
         for (Iterator iter = result.iterator(); iter.hasNext();)
         { 
            Users user = (Users) iter.next();
            ret = user.getActions();      
         } 
      }

[/code]

nathanmoon · **Posted:** Fri May 04, 2007 5:27 pm

Code:

Users user = (Users) session.createQuery("from Users as user where NAME='"+name+"'").uniqueResult();

uniqueResult() will throw an exception if the query returns more than one row, so be careful.

as a side note, you should make your query static, and use variables, i.e.

Code:

Users user = (Users) session.createQuery("from Users as user where NAME=:name).setString("name",name).uniqueResult();

that allows your query to be cached, which is better for performance.

xaeryan · **Joined:** Fri May 04, 2007 3:43 pm **Posts:** 18

Thanks for the response. As for your suggestion, how does one come upon that information? What I mean is, where can I learn tips like that to make my code more efficient?

nathanmoon · **Posted:** Fri May 04, 2007 9:21 pm

I think the Hibernate book gets into it. Or you can pick up things like that by searching in and reading this forum (and posting questions).