Pfthb

It looks like Spring Data Redis does not support the IsIn, In queries yet. I am not sure if there is any other of way of doing it as its very basic queries. It was either to be happned using Spring Data Redis or RestTemplate.

java.lang.IllegalArgumentException: IN (1): [IsIn, In]is not supported for redis query derivation
 at org.springframework.data.redis.repository.query.RedisQueryCreator.from(RedisQueryCreator.java:67)
 at org.springframework.data.redis.repository.query.RedisQueryCreator.create(RedisQueryCreator.java:53)
 at org.springframework.data.redis.repository.query.RedisQueryCreator.create(RedisQueryCreator.java:41)
 at org.springframework.data.repository.query.parser.AbstractQueryCreator.createCriteria(AbstractQueryCreator.java:119)
 at org.springframework.data.repository.query.parser.AbstractQueryCreator.createQuery(AbstractQueryCreator.java:95)
 at org.springframework.data.repository.query.parser.AbstractQueryCreator.createQuery(AbstractQueryCreator.java:81)
 at org.springframework.data.keyvalue.repository.query.KeyValuePartTreeQuery.createQuery(KeyValuePartTreeQuery.java:211)
 at org.springframework.data.keyvalue.repository.query.KeyValuePartTreeQuery.prepareQuery(KeyValuePartTreeQuery.java:148)
 at org.springframework.data.keyvalue.repository.query.KeyValuePartTreeQuery.execute(KeyValuePartTreeQuery.java:106)
 at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:602)
 at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:590)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
 at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
 at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
 at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
 at com.sun.proxy.$Proxy76.findByNameIn(Unknown Source)
 at com.mastercard.customer.program.UserGroupTest.test(UserGroupTest.java:58)

Group.java

@Builder
@Data
@AllArgsConstructor
@NoArgsConstructor
@RedisHash("groups")
public class Group 
 @Id
 private Long groupId;
 private String name;

User.java

@Builder
@Data
@AllArgsConstructor
@NoArgsConstructor
@RedisHash("users")
public class User 
 @Id
 private Long userId;
 private String name;

UserGroupTest.java

@Log4j
@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest
public class UserGroupTest extends RepositoryTestSupport
 @Autowired UserRepository userRepository;
 @Autowired GroupRepository groupRepository;

 @Before
 public void setUp() 
 User user1 = User.builder().userId(1L).name("John").build();
 User user2 = User.builder().userId(2L).name("Sally").build();
 User user3 = User.builder().userId(3L).name("Chris").build();

 Group group1 = Group.builder().groupId(1L).name("Nature-Group").build();
 Group group2 = Group.builder().groupId(2L).name("Music-Group").build();
 Group group3 = Group.builder().groupId(3L).name("Sports-Group").build();

 userRepository.save(user1);
 userRepository.save(user2);
 userRepository.save(user3);

 groupRepository.save(group1);
 groupRepository.save(group2);
 groupRepository.save(group3);
 

 @Test
 public void test() 
 List<User> users = userRepository.findByNameIn(Arrays.asList("John", "Sally"));
 System.out.println(users.size());
 

Spring Data Redis 2.1.2 (recent version at the time of writing) does not support In queries through query derivation. There is a ticket to support the In query type.