Native query and JPA cache

Question

Does the inline query in JPA ( createNativeQuery ) createNativeQuery caching?
I populate my own data transfer object because the sql query joins several tables and displays only a few columns.

Hi

Answer 1

It is possible, but you should use explicit .addScalar or .addEntity .

see also

• SQL query problem caching
• Hibernate: Truly Understanding L2 Caches and Queries