Invalid object name 'HFJ_RESOURCE' when using MS SQL Server 2019 and Hapi Docker v6.6.0

[Binoy Nair]

Hello!

I am trying to run HAPI FHIR from Docker Hub image v6.60 the option below: 

using configuration via overridden application.yaml file and using Docker

docker run -p 8080:8080 -v "$(pwd)/configs:/configs" -e "--spring.config.location=file:///configs/another.application.yaml" hapiproject/hapi:v6.6.0

I have MS SQL Server 2019 configured locally on Windows 10, and Hapi FHIR v6.6.0 image running on docker desktop.

I get the following error:

Hibernate: SELECT top(?) t0.RES_ID FROM HFJ_RESOURCE t0 WHERE ((t0.RES_TYPE = ?) AND (t0.RES_DELETED_AT IS NULL))
2023-08-20 21:28:32.643 [main] WARN  o.h.e.jdbc.spi.SqlExceptionHelper [SqlExceptionHelper.java:137] SQL Error: 208, SQLState: S0002
2023-08-20 21:28:32.644 [main] ERROR o.h.e.jdbc.spi.SqlExceptionHelper [SqlExceptionHelper.java:142] Invalid object name 'HFJ_RESOURCE'.

  datasource:

    url: 'jdbc:sqlserver://localhost:1433;databaseName=hapifhir;trustServerCertificate=true'

    #url: jdbc:h2:mem:test_mem

    username: hapifhir

    password: password

    driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver

    max-active: 15

    # database connection pool size

    hikari:

      maximum-pool-size: 10

  jpa:

    properties:

      hibernate.format_sql: false

      hibernate.show_sql: true

       

      #Hibernate dialect is automatically detected except Postgres and H2.

      #If using H2, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirH2Dialect

      #If using postgres, then supply the value of ca.uhn.fhir.jpa.model.dialect.HapiFhirPostgres94Dialect

      hibernate.dialect: org.hibernate.dialect.SQLServer2016Dialect

      hibernate.default_schema: dbo

I have attached the log file, another,application.yaml and snapshot of SQL Server FHIR DB. The database tables have a default schema of dbo. I have tried adding/removing hibernate.default_schema to see if that helps, also tried v6.4.4 docker hapi image.. but same error. Also, adding/removing base SQLServer dialect .. same error.

Appreciate your help in resolving the error.

Thanks,

B

[Binoy Nair]

The MS SQL Server 2019 hapifhir db Collation is set to be case sensitive as per https://github.com/hapifhir/hapi-fhir-jpaserver-starter

Thanks,

B