Hibernate : getting multiple table columns results from multiple tables

Question

I am using hibernate 4 and Spring 3.

I have 5 tables and each table is mapped with 1 entity class.Now if I have to select columns from 1 table than i will do below :

String hql = "from Employee E";
Query query = session.createQuery(hql);
List results = query.list();

This value in this result will be of type EmployeeEntity.

Or I can use Criteria as well.

Now my requirnment is that I have to get the result from all 5 tables.1-2 columns from each table.

Earlier it was one 1 table so i was getting one entity , now I am getting results from 5 tables so how to map it in entity.

List results1 = query.list(); // considering select and getting 6 columns in results with diffenent tables.

Now how to iterate this result1.

I hope you got my question.

Darshan Lila · Accepted Answer · 2014-08-29 09:10:39Z

1

You can use Result Set Transformer of Query:

Say you have 4 columns from different tables like tab1col,tab2col,tab3col,tab4col.

Create a 'POJO' as follows

class MyClass
{
 private Integer tablcol;
 private Integer tab2col;
 private Integer tab3col;
 private Integer tab4col;
  //  getter and setters
}

Following way you can transform you result set:

List<MyClass> myClassList=query.setResultTransformer(Transformers.aliasToBean(MyClass.class)).list();

Note: query should contain a result set(something like cursor in oracle).

answered Aug 29, 2014 at 9:10

Darshan Lila

5,8762 gold badges26 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

VJS Over a year ago

Thanks. Means here we will get list of type MyClass but how queries columns will set to specific fields. Like 1st column of select will map to which MyClass variable.How to determine ?

Darshan Lila Over a year ago

Just keep class's field name same as column name, hibernate will handle rest.

VJS Over a year ago

Thank You for your prompt response.

Collectives™ on Stack Overflow

Hibernate : getting multiple table columns results from multiple tables

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related