java.lang.ClassCastException: org.hibernate.internal.QueryImpl cannot be cast to com.models.User

Question

I have a user table structured this way

id    name     email
1     cc       [email protected]
2     rr       [email protected]
3     cc       [email protected]

I am writing a query to save a log when ever it finds an email matching any of the row with the below hql

String hql = "FROM User c WHERE c.email = :email order by c.id";
        return (User) _sessionFactory.getCurrentSession().createQuery(hql).setParameter("email", email);

When I run my code I get this error

java.lang.ClassCastException: org.hibernate.internal.QueryImpl cannot be cast to com.models.User
    at com.models.UserDao.getByEmail(UserDao.java:62)

It seems that you are missing the .getResultList() at the end of your command. — Julian
– Julian, Commented Aug 8, 2016 at 18:20
@Francis so it makes no sense to cast it to a User object since the result will provide you with something else, you need to get the first result and then cast it to a user. — Lin
– Lin, Commented Aug 8, 2016 at 18:21

Nicolas Filotto · Accepted Answer · 2017-02-02 17:58:28Z

2

You forgot to call uniqueResult() to get the first result, the code should rather be:

 return (User) _sessionFactory.getCurrentSession().createQuery(hql)
    .setParameter("email", email)
    .uniqueResult();

Indeed you get this error because you try to cast a Query instance into a User which cannot be done, you need to execute the query first to get your User instance.

If you want to get several results then consider using list(), the code will then be something like:

 return (List<User>) _sessionFactory.getCurrentSession().createQuery(hql)
    .setParameter("email", email)
    .list();

edited Feb 2, 2017 at 17:58

answered Aug 8, 2016 at 18:21

Nicolas Filotto

45.2k11 gold badges97 silver badges129 bronze badges

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

2 Comments

Francis Over a year ago

what about if i want to get the third row

Julian Over a year ago

Yeah, that's why i asked if he needed one or more than one result. @NicolasFilotto

Julian · Accepted Answer · 2016-08-08 18:22:47Z

1

It seems that you forgot to call the getResultList() method at the end.

return (List<User>) _sessionFactory.getCurrentSession().createQuery(hql)
              .setParameter("email", email)
              .getResultList();

You should notice that since you are expecting more than one result, you'll need to change this command a bit or adapt the code to where this is returning to.

answered Aug 8, 2016 at 18:22

Julian

3441 silver badge11 bronze badges

Comments

Arun Raaj · Accepted Answer · 2019-06-15 15:17:11Z

0

You have to extract your result out of Query. You can extract a single Object by using

.createQuery(hql).getSingleResult();

answered Jun 15, 2019 at 15:17

Arun Raaj

1,7781 gold badge22 silver badges20 bronze badges

Collectives™ on Stack Overflow

java.lang.ClassCastException: org.hibernate.internal.QueryImpl cannot be cast to com.models.User

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related