Joel Schneider (NMDP)

Today I found that setting the Hibernate property `hibernate.hbm2ddl.auto=validate` prevents the server from printing the "Error executing DDL" stack traces. E.g.: ``` java -Xmx4096m '-Dspring.datasource.url=jdbc:mysql://localhost:3306/fhir_r4?useSSL=false' -Dspring.datasource.username=myuser -Dspring.datasource.password=secret -Dspring.datasource.driverClassName=com.mysql.cj.jdbc.Driver -Dspring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL57Dialect -Dspring.jpa.properties.hibernate.hbm2ddl.auto=validate...

This issue is related to MySQL identifier case sensitivity (e.g. for table names) being linked to the case sensitivity of the underlying operating system. See also: https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html The MySQL server...

Another slightly strange part of this story is, only the hapi-fhir-jpaserver-starter FHIR server was affected by the MySQL lower_case_table_names=1 setting. The other FHIR server based on hapi-fhir-jpaserver-uhnfhirtest was not affected...

It looks like [https://bitbucket.org/hspconsortium/sandbox-manager](https://bitbucket.org/hspconsortium/sandbox-manager) has been changed to a private Bitbucket repository.

Thanks for the quick response.