Hibernate java.sql.SQLException: No value specified for parameter 1

Question

I want to extract all events from db wherein User joined.

DAO :

public List<Event> getUserJoinedEvents(User user) {
        return sessionFactory.getCurrentSession()
                .createQuery("FROM Event event WHERE event.eventMembersJoined = :user")
                .setParameter("user", user).list();

Entity:

...  
 @JoinTable(name="MEMBERS_JOINED_EVENT", 
                        joinColumns={@JoinColumn(name="JOINED_EVENT_ID")}, 
                        inverseJoinColumns={@JoinColumn(name="USER_ID")})
        private Set<User> eventMembersJoined = new HashSet<User>();
...

And as result got exception:

java.sql.SQLException: No value specified for parameter 1

What did I miss?

Predrag Maric · Accepted Answer · 2014-12-27 08:58:05Z

2

eventMembersJoined is a Set, but you compare it using = with parameter of type User. To check weather a set contains certain element, try with this:

FROM Event event WHERE :user in elements(event.eventMembersJoined)

answered Dec 27, 2014 at 8:58

Predrag Maric

24.5k5 gold badges57 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Hibernate java.sql.SQLException: No value specified for parameter 1

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