Join and DTO

krisreid · **Joined:** Sun Oct 11, 2009 7:17 pm **Posts:** 8

Hi

I have a HSQL query that uses many tables and I'm not sure how to access the results.

To simply things

I have the following code

Code:

Session s = HibernateUtil.getCurrentSession();
SQLQuery query = s.createSQLQuery("select customer.name, business.location from customer, business");
      
query.list();

What are the objects returned in the list?

Can I make a class just for those results?

Code:

class Results {
     String name;
     String location;
}

Cheers

krisreid · **Joined:** Sun Oct 11, 2009 7:17 pm **Posts:** 8

A legendary friend has already pointed me to the answer

Query query = s.createSQLQuery(SQL_QUERY).setResultTransformer(Transformers.aliasToBean(TestDTO.class));

TestDTO is a DTO that for this example has two Strings with getters and setters. Hibernate will populate it for you and job done!