How to retrieve data from object in hibernate

Question

I want to join two table: T1:id,name,email T2:id,address

to join I am doing this:

String hql="select sd.name,tt.name from T1 sd,T2 tt where sd.id=tt.id";
            Query q=ss.createQuery(hql);
            List l2=q.list();
            Object o1=l2.get(0);
            System.out.println("-----------");
            System.out.println(o1.toString());
            System.out.println("-----------");

It is returning object but dont get how to retrieve the values as returned object is not entity object.

Maybe this answers your question http://stackoverflow.com/questions/13607337/hibernate-query-for-selecting-multiple-values — RubioRic, Mar 21 '16 at 06:13
I'm certain there are better, more automated ways, to do this but as written it's a little difficult to gleam what you're actually asking. — ChiefTwoPencils, Mar 21 '16 at 06:18

score 1 · Accepted Answer · answered Mar 21 '16 at 06:45

1

Every result is an Object Array.The Array's size is the select columns

List l2=q.list();
Object[] o1=(Object[])l2.get(0);//The size is should be 2
System.out.println(o1[0]);
System.out.println(o1[1]);

answered Mar 21 '16 at 06:45

Conant

60
5

Thanks ... it is like RubioRic's ans. – Rake Mar 24 '16 at 08:00

score 0 · Answer 2 · edited May 23 '17 at 12:31

0

You have to cast the Object's in the List to your specific type, Hibernate does not know the type. See What is the "proper" way to cast Hibernate Query.list() to List<Type>? and Hibernate query for selecting multiple values

edited May 23 '17 at 12:31

Community

1
1

answered Mar 21 '16 at 07:41

Raphael Roth

26,751
15
88
145

score 0 · Answer 3 · answered Mar 21 '16 at 09:25

0

it will return array of Object which you need to typecast as per your select values like name etc.

List<Object[]> values= (List<Object[]>)q.list();
     for(Object[] val: values){

....
//your specific type values
}

answered Mar 21 '16 at 09:25

Sai prateek

11,842
9
51
66

Thanks ... it is like RubioRic's ans – Rake Mar 24 '16 at 08:00

score 0 · Answer 4 · answered Mar 21 '16 at 09:48

0

Another option is creating a view with your joined tables, then, create hibernate entity base on that view

answered Mar 21 '16 at 09:48

VinhNT

1,091
8
13

How to retrieve data from object in hibernate

4 Answers4