hibernate list in list search

[Vladimir Koba]

Hi folks!
I've a class User:

public class User{
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private long id;
    @Column(nullable = false, unique = true, length = 40)
    private String login;
    @Column
    private String password;
    @Column(length = 120)
    private String fio;
//
    @ElementCollection(fetch = FetchType.EAGER)
    private Set<UserPrivilege> privilegies = new HashSet<UserPrivilege>();

And enum with user privileges:

public enum UserPrivilege {
//Many privilegies, like
CREATE_TASK,
DELETE_TASK,
etc
}

I need a HQL query, which return all users, who has all priviligies by set.
Rougtly,

List<User> getUsersByPrivilegies(Set<UserPriviligies> privilegies).

My query:
from User u where (u.privilegies) in (:privilegies);,

And execute:

Set<UserPriviligies> privs = new HashSet<UserPriviligies>();
privs.add(UserPriviligies.CREATE_TASK);
..
Query query = hibernateTemplate.getSessionFactory().openSession().createQuery(GET_USERS_BY_PRIVILEGE_QUERY);
query.setParameterList("privilegies", privs);
query.list();

I've an error:

com.mysql.jdbc.JDBC4PreparedStatement@683bb3af: select user0_.id as id3_, user0_.fio as fio3_, user0_.login as login3_, user0_.password as password3_ from User user0_ cross join User_privilegies privilegie1_ where user0_.id=privilegie1_.User_id and (. in (** NOT SPECIFIED **))
17:03:12,440  WARN JDBCExceptionReporter:233 - SQL Error: 0, SQLState: 07001
17:03:12,440 ERROR JDBCExceptionReporter:234 - No value specified for parameter 1
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.doList(Loader.java:2536)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	at org.hibernate.loader.Loader.list(Loader.java:2271)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	at ru.igs.eq.service.impl.UserServiceImpl.getUsersByRole(UserServiceImpl.java:71)
	at Main.main(Main.java:37)
Caused by: java.sql.SQLException: No value specified for parameter 1
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
	at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2513)
	at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2489)
	at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2415)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2169)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
	at org.hibernate.loader.Loader.doQuery(Loader.java:802)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	at org.hibernate.loader.Loader.doList(Loader.java:2533)
	... 9 more

I have'nt idea, why "No value specified for parameter 1"..
thanks in advance!