Cache Query Result in Spring JPA in ArrayList

Question

I have a query result in spring data Like :

public interface user extends extends CrudRepository<UserRegistration, Long> {
@Query(value="select ur from UserRegistration ur where "
        + " ur.location.id IN ?1 AND"
        + " ur.event.id IN ?2")
        public List<UserRegistration> getUsersBylocationAndEvent(long[] locationList, long[] eventList);
}

and use this method in service implementation as

public class userServiceImpl implements userService{
@Autowired
UserRegistrationRepository userRegistrationRepository;

@Override
public List<UserRegistration> getUserRegistarationByEventAndLocation(long[] locationList, long[] eventList, int checkInFlag, Date checkInDate, int checkOutFlag, Date checkOutDate) {
    List<UserRegistration> userRegistrationList = userRegistrationRepository.getUserRegByLocationIdsAndEvenIds(locationList, eventList);

    return userRegistrationList;
}}

And I used this method "getUserRegistarationByEventAndLocation()" in multiple webServices, so I want to cache the result when first webservice called in list and can use this list in other webService.

make list a member variable and check if content exists. not sure if this is what you are looking for — XtremeBaumer
– XtremeBaumer, Commented May 31, 2017 at 10:15

Lova Chittumuri · Accepted Answer · 2017-05-31 13:11:14Z

1

we can use the @Cacheable annotation. it might be helpful

 @Cacheable(value="UserRegistration")
  List<UserRegistration> getUserRegByLocationIdsAndEvenIds(locationList, eventList);
  {

  }

answered May 31, 2017 at 13:11

Lova Chittumuri

3,4011 gold badge38 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Cache Query Result in Spring JPA in ArrayList

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