org.hibernate.SQLQuery output to an object

Question

I have a table by name Person and it has only one row data. I dont want to take it in list(). Can I get the data of Object type. Below is my code snippet

Session session = this.sessionFactory.openSession();
String sql = "SELECT * FROM PERSON";
SQLQuery query = session.createSQLQuery(sql);
query.addEntity(Person.class);
List<Person> list = query.list();

===================================

I want the above code snippet to work as below:

Session session = this.sessionFactory.openSession();
String sql = "SELECT * FROM PERSON";
SQLQuery query = session.createSQLQuery(sql);
query.addEntity(Person.class);
Person p = query;

which is throwing error. Please help me out on fixing the issue.

When need an explanation first give us your exception error

hurricane
– hurricane

2016-01-08 09:49:31 +00:00
Commented Jan 8, 2016 at 9:49 — hurricane
– hurricane, Commented Jan 8, 2016 at 9:49

hurricane · Accepted Answer · 2016-01-08 09:49:06Z

2

query is result of your session select. query.list() is your results. and you can get with query.list().get(0);

You can cast query list to personList;

List<Person> list = query.list();
return list.get(0);

You can just cast your result to person;

Person p = (Person) query.list().get(0);

answered Jan 8, 2016 at 9:49

hurricane

6,7342 gold badges39 silver badges45 bronze badges

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

1 Comment

Subramanya K Over a year ago

Hurricane you are just awesome. It worked. Thanks a loads.

Collectives™ on Stack Overflow

org.hibernate.SQLQuery output to an object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related