Spring Data JPA repositories: IN-clause in derived query not working

Try it without the brackets

@Query("select u from User u where u.id in :ids")

Latest version of Spring Data JPA supports IN keyword which can be used to create the query like the following:

Set<User> findByIdIn(Set<Long> ids);