java.lang.ClassCastException: org.hibernate.internal.SQLQueryImpl cannot be cast to java.util.List how to fix

Question

 List<Candidate> candidates = (List<Candidate>) session.createSQLQuery("select candidate.* from candidate inner join candidate_skill on candidate.id = candidate_skill.candidate_id inner join skill on candidate_skill.skill_id = skill.id where skill.id = 1");

And I see:

 java.lang.ClassCastException: org.hibernate.internal.SQLQueryImpl cannot be cast to java.util.List

Query is correct. How to fix it?

kosa · Accepted Answer · 2013-08-09 14:02:17Z

13

You forgot .list() at end of the query.

It should be something like

................skill.id where skill.id = 1").list();

Refer hibernate documentation for more information.

answered Aug 9, 2013 at 14:02

kosa

66.7k15 gold badges134 silver badges170 bronze badges

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

7 Comments

user2645679 Over a year ago

Can You help get real List<Candidate>, now I get array of object, which consist of array of fields

kosa Over a year ago

@user2645679: You need to loop List<Object[]>, get Object[] and do lookup based on index, index 0 reporents first column data, index 1 represents second coulmns etc., populate that to Candidate Object.

user2645679 Over a year ago

is there no better solution?

kosa Over a year ago

@user2645679: Not I know of when you are using native SQL.

user2645679 Over a year ago

HQL can be helpfull for this situation?

|

Suresh Atta · Accepted Answer · 2013-08-09 14:03:04Z

2

Query not returning any thing and you are trying to assign it to List

You should do

 List<Candidate> candidates = (List<Candidate>) session.createSQLQuery
               ("select candidate.* from candidate inner join 
                    candidate_skill on candidate.id = candidate_skill.
                        candidate_id inner join skill on 
                  candidate_skill.skill_id = skill.id 
                                          where skill.id = 1").list();

A simple native query example

answered Aug 9, 2013 at 14:03

Suresh Atta

122k38 gold badges206 silver badges315 bronze badges

2 Comments

user2645679 Over a year ago

I think, you can help for write this query using HQL. I want to get List<Candidates>

Suresh Atta Over a year ago

Why query ,i would like suggest criteras..please have a look on criterias.

Collectives™ on Stack Overflow

java.lang.ClassCastException: org.hibernate.internal.SQLQueryImpl cannot be cast to java.util.List how to fix

2 Answers 2

7 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related