How to add QueryHints on Default Spring Data JPA Methods?

Question

I am able to use Query Cache with Spring Data JPA for my custom query methods like below.

public interface CountryRepository extends JpaRepository<Country, String> {
@QueryHints({ @QueryHint(name = "org.hibernate.cacheable", value ="true") })
Country findByCountryName(String countryName);
@QueryHints({ @QueryHint(name = "org.hibernate.cacheable", value ="true") })
Country findByCountryCode(String countryCode); }

However, how to add @QueryHints on existing parent methods like findAll()?

Thanks.

I have the same problem. I tried to override them and add the @QueryHint annotations, but they are ignored. — Agustí Sánchez, Apr 06 '14 at 23:09
@user791694, see sgp15's answer at below http://stackoverflow.com/a/10876707/418439 — Lee Chee Kiam, Apr 07 '14 at 01:12

score 6 · Accepted Answer · answered Jun 04 '12 at 05:37

6

findAll(), findOne() etc. are not Query(s). Any caching specifications on the entity take effect in these methods.

For example,

@Cacheable
@Entity
public class User {

}

answered Jun 04 '12 at 05:37

sgp15

1,280
8
13

I have these set and the for findAll it goes to database. Is there anything I need to turn on ? – Piotr Gwiazda Apr 07 '15 at 11:18
@ Cacheable doesn't seem to have any effect on findAll(). My understanding is that findOne() is linked to the "Level 2 cache" but findAll() linked to the "Query cache". To cache the findAll(), i've override the method and add the @ queryhints. – Y.M. Dec 27 '16 at 21:22

score 1 · Answer 2 · answered Apr 06 '14 at 23:27

1

Originally, there was no support for query hint annotations in default CRUD methods, but apparently it hass been fixed for version 1.6M1:

https://jira.spring.io/browse/DATAJPA-173

answered Apr 06 '14 at 23:27

Agustí Sánchez

10,455
2
34
25

How to add QueryHints on Default Spring Data JPA Methods?

2 Answers2

Linked