Append two hibernate query list and store in third query list

Question

The first table contain list from Database and store in qry and the second table also contain list from Database and store in qry1 then how to append these list in the third qry2.

Query qry = getSession().createQuery("select * from table1");
Query qry1 = getSession().createQuery("select * from table2");
Query qry2 = dry+qry1;

Suresh Atta · Accepted Answer · 2015-07-29 08:52:20Z

1

Why don't you simple do

List<Object> result = new ArrayList<Object>();
result.addAll(qry.list());
result.addAll(qry1.list());

You have to take a List of Object's since the both Pojo's are different from table1 to table2.

answered Jul 29, 2015 at 8:52

Suresh Atta

122k38 gold badges206 silver badges315 bronze badges

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

Collectives™ on Stack Overflow

Append two hibernate query list and store in third query list

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related