Cast hibernate Query result to Object of type class instead of list array

Question

Is there any way to Cast hibernate Query result to Object instead of list array.

Query q1 = session.createQuery("from userTable where id ='1234'");

List userList = q1.list(); >> cast to object of UserBean class type ??

UserBean user = (UserBean)userList.get(0); 

System.out.println(user.getName);
System.out.println(user.getAge);
.....
System.out.println(user.getPhone);

UserBean class is mapped with a table name userTable and i wish to get the column value of one id which is primary key of the table.

Please see at line 2, List userList = q1.list() ?? can we cast/convert to object of type class anyhow.

@Reimeus Many thanks. it works. Please put this comment in answer so i would be able to accept your answer. — user1010399
– user1010399, Commented Jul 22, 2013 at 10:16

Priyank Doshi · Accepted Answer · 2013-07-22 09:53:03Z

2

Why don't you use this?

UserBean user = (UserBean) q1.getSingleResult();

answered Jul 22, 2013 at 9:53

Priyank Doshi

13.2k18 gold badges61 silver badges82 bronze badges

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

3 Comments

user1010399 Over a year ago

but i am getting a compiler error, The method getSingleResult() is undefined for the type Query, any suggestion ?

user1010399 Over a year ago

hello priyank, may u please clarify bit more about the method ?

Priyank Doshi Over a year ago

@user1010399 : Its a method of Query Interface. See docs.oracle.com/javaee/5/api/javax/persistence/… for more info. You shouldn't be getting compilation error.

Reimeus · Accepted Answer · 2013-07-22 10:17:17Z

1

Try this

UserBean user = (UserBean) q1.uniqueResult();

answered Jul 22, 2013 at 10:17

Reimeus

160k16 gold badges225 silver badges282 bronze badges

Collectives™ on Stack Overflow

Cast hibernate Query result to Object of type class instead of list array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related