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 stackoverflow.com/questions/13607337/… — RubioRic
– RubioRic, Commented Mar 21, 2016 at 6: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
– ChiefTwoPencils, Commented Mar 21, 2016 at 6:18

Conant · Accepted Answer · 2016-03-21 06:45:33Z

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]);

Community · Accepted Answer · 2017-05-23 12:31:30Z

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

Sai prateek · Accepted Answer · 2016-03-21 09:25:19Z

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 }

VinhNT · Accepted Answer · 2016-03-21 09:48:02Z

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

Collectives™ on Stack Overflow

How to retrieve data from object in hibernate

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Linked

Related