Hibernate Template Query

Question

I am using Hibernate Template to store and get data from my database. I am trying to check if the user already exists in database or not. What I have tried is

public class UserDaoImpl implements UserDao {

    private HibernateTemplate hibernateTemplate;

    @Autowired
    public void setSessionFactory(SessionFactory sessionFactory) {
        hibernateTemplate = new HibernateTemplate(sessionFactory);
    }

    @Override
    public List<User> findUser(Integer socialId) {
        String queryString = "SELECT * FROM users WHERE users.validatedId = ?";
        return hibernateTemplate.find(queryString, socialId);
    }
}

but it says Type mismatch: cannot convert from List < capture#2-of ? > to List< User >

Thanks

First you need to read this http://stackoverflow.com/questions/18002768/why-hibernatetemplate-isnt-recommended Why using hibernatetemplate isn't recommended Or you can read this http://stackoverflow.com/questions/5104765/hibernatedaosupport-is-not-recommended-why — Sambhav Sharma, Apr 28 '14 at 12:05

geoand · Accepted Answer · 2014-04-28T19:20:03.140

0

Use the following query:

FROM User u WHERE u.validatedId = ?

Also you need to type cast to List<User> since HibernateTemplate.find simple returns List with no generics.

edited Apr 28 '14 at 19:20

answered Apr 28 '14 at 12:04

geoand

60,071
24
172
190

Changing the query does not remove the error it says you need to cast to List – Wearybands Apr 28 '14 at 12:09
Does it not work when you cast? You need to cast since find does not use generics – geoand Apr 28 '14 at 12:10
Not tested but when I cast it gives warning Type safety warning – Wearybands Apr 28 '14 at 12:12
There is no way you can avoid the casting and the type warning, since HibernateTemplate.find simply returns List, not List. Please try it out and let me know – geoand Apr 28 '14 at 12:13
the app is not running bcz of some ip restrictions I will check it in home and will let you know – Wearybands Apr 28 '14 at 12:28
@UmairIqbal Ok, no problem – geoand Apr 28 '14 at 12:34
It gives the following error org.hibernate.hql.internal.ast.QuerySyntaxException: users is not mapped [FROM users u WHERE u.validatedId = ?] . May table name is users – Wearybands Apr 28 '14 at 19:16

score 0 · Answer 2 · answered Feb 04 '16 at 20:39

0

return (List<User>)(List<?>)hibernateTemplate.find(queryString, socialId);

answered Feb 04 '16 at 20:39

Raptor

1

Hibernate Template Query

2 Answers2