Hibernate named query error

Question

I have a problem with a named query but I don't get it why it doesn't work.

This is how I define the queries:

@NamedQueries({
    @NamedQuery(
        name = Rating.FIND_ALL,
        query = "from Rating"
    ), 

    @NamedQuery(
        name = "getUserRatings",
        query = "SELECT s from Rating s where s.user_id = :user_id"
    )
})

and here I use it:

public List<Rating> getUserRatings(User user){
    return em.createNamedQuery("getUserRatings", Rating.class).setParameter("user_id", user.getId()).getResultList();
}

error: Caused by: org.hibernate.HibernateException: Errors in named queries: getUserRatings

Jay · Accepted Answer · 2014-04-30 11:35:38Z

2

NamedQuery cannot have native query. Check if you have user_id in your entity. user_id seems like a column in DB. If so change it to java field

SELECT s from Rating s where s.userId = :user_id

answered Apr 30, 2014 at 11:35

Jay

9,55914 gold badges63 silver badges101 bronze badges

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

Collectives™ on Stack Overflow

Hibernate named query error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related