Using @NaturalId for cache

[jhhong0509]

I'm using @NaturalId annotation in my User.email.
I expected that my findByEmail(String email) would enable to search in first level cache or second level cache.
But in log, cache does not work as I think.
Every findByEmail method were access DB.

I used bySimpleNaturalId() for my purpose, but it's very hassle.
Please make @NaturalId access to cache enable

[schauder]

This is an interesting proposal. Lets wait until it is actually part of JPA: jakartaee/persistence#320

We try to avoid implementation specifics in Spring Data JPA.

[nightswimmings]

Is it really necessary having to go through findByNaturalId()? If you already mark the natural id foo field as @naturalid, perhaps it can be some way to make loadByFoo automatically marked internally as a NaturalId, and through reflection, cache it

[schauder]

Yes, because Spring Data JPA certainly won't get into caching itself.

[nightswimmings]

I meant caching it though hinting the JPA Provider.
Idk, it's just that it feels so antifunctional to use findByNaturalId() when findByEmail(), findByISBN() or findByName() is so readable :,(

[ratsam]

I know this is an old issue, but for anyone arriving here from Google search, this project might help: https://github.com/pocketcombats/spring-data-naturalid