"from unexpected" when createQuery

Question

I get a error when I createQuery:

'from' unexpected

My code is below:

    @Override
    public Admin findByAdmin(Admin admin) {

        return (Admin) sessionFactory.getCurrentSession().
                createQuery("from Admin where admin_name=? and pwd=?").
                setParameter(0, admin.getAdminName()).
                setParameter(1, admin.getAdminPwd()).
                uniqueResult();

    }

The query syntax looks OK, this might be a bug in the IDE's parsing of HQL. If you compile and run does the code actually work? — Jim Garrison, Mar 18 '17 at 06:44
@JimGarrison It can run, but get a 404, I don't know if is caused by the issue. I think have possibility is the IDE's parsing of HQL bug too. — user7693832, Mar 18 '17 at 06:58

Prashant · Answer 1 · 2023-06-30T18:13:52.267

34

To fix this error in intelliJ idea

Your Project (Right-Click) ---> Framework support : check mark on "Hibernate"

Press OK.

edited Jun 30 '23 at 18:13

answered Jun 12 '17 at 16:01

Prashant

616
6
10

This added a hibernate facet, I already had the JPA facet but seems this wasn't enough. – Andrew Jan 24 '21 at 21:05

score 32 · Accepted Answer · answered Apr 11 '17 at 08:46

32

I'm new to this but had the same error. What fixed things was adding the Hibernate facet under Project Structure - Facets.

answered Apr 11 '17 at 08:46

Ramona Florina Barbieru

336
3
4

score 0 · Answer 3 · answered Mar 12 '21 at 07:27

If you can't find Hibernate in your Project Structure settings (File --> Project Structure... --> Facets) then go to File --> Settings --> Plugins and type Hibernate in search field and verify if plugin is added to Intellij. After that you will find it under Facets in your project settings and add support.

In my case this was what helped me.

"from unexpected" when createQuery

3 Answers3

To fix this error in intelliJ idea