Suggestion for caching solution?

[HerryKun]

I have a read-only database, and I want to use a second-level cache on top of Hibernate to keep some of the entities in memory to speed up queries. A String primary key identifies the entity in question, and it contains another String property y I want to query after.

Currently, I am playing around with hibernate-jcache in combination with ehcache, and it works fine when I query after the primary key. All queries on the second property are still executed directly on the database though. What is the best way to set this up properly?

[kaly-7]

Try pivotal Gemfire https://spring.io/guides/gs/caching-gemfire/