Hibernate Caching Inoperable

[theGOTOguy]

Describe the bug Attempting to enable Hibernate caching causes HAPI to fail to inject essential resources, and the server fails to start.

To Reproduce The behavior is easy to see in the current version of the JPA server.

docker run -e spring.jpa.properties.hibernate.cache.use_query_cache=true hapiproject/hapi:latest

or

docker run -e spring.jpa.properties.hibernate.cache.use_second_level_cache=true hapiproject/hapi:latest

reproduces the behavior. The root error is, e.g.:

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [ca/uhn/fhir/jpa/starter/FhirServerConfigR4.class]: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.cache.spi.RegionFactory]

Expected behavior HAPI FHIR should start correctly if caching is enabled.

Environment (please complete the following information):

• HAPI FHIR Version: hapiproject/hapi:latest
• OS: docker
• Browser: n/a

[psavva]

I can confirm the same

+1

[jamesagnew]

HAPI FHIR JPA is not designed to work with the hibernate 2nd level cache feature. We implement a business level caching layer on top of hibernate (it can be found in MemoryCacheService) which makes the 2nd level cache mostly redundant.