Making many to many relationship cacheable in JPA

Question

I have many-to-many relationship between User and Role. There is a third table called UserRole mapped as a join-table.

In JPA I can cache User and Role using @Cachable; however when I try to fetch the Roles associated to the User which is defined EAGER, a database query is executed to fetch the values from the join-table.

How can I cache the join-table between User and Role?

Answer 1

Decide your caching concurrency strategy based on here and use @Cache on top of your association:

    @org.hibernate.annotations.Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE, region = "user_roles")

Make sure to mark the both entities (in this case User and Role) with @Cacheable too.