Stream: hapi
Topic: install hapi fhir with postgres
DevGeek (Jul 10 2020 at 16:26):
Hi, I'm a js developer so I'm new to java / spring etc .. I installed the jpa server starter , it was installed with Derby DB ! I need to install it with PostGres , so what version do I use (starter , spring boot etc .. ) ? and how can I do it ? I already searched before asking so any help will be apperciated.
Richard Stanley (Jul 11 2020 at 15:29):
There are instructions on jpa-starter for Postgres. For docker, here’s a gist to help: https://gist.github.com/citizenrich/ef644ea195106a771717e8c234e525b3
Richard Stanley (Jul 11 2020 at 15:31):
The gist covers docker with Postgres
DevGeek (Jul 14 2020 at 13:46):
https://groups.google.com/g/hapi-fhir/c/OMKMBIFozHs
DevGeek (Jul 14 2020 at 14:18):
Please who can help me with this error when configuring Postgres : https://groups.google.com/g/hapi-fhir/c/OMKMBIFozHs
DevGeek (Jul 14 2020 at 15:00):
After configuring PostgreSQL like this hapi.propreties :
datasource.driver=org.postgresql.Driver
datasource.url=jdbc:postgresql://IP:5432/hapi_database
hibernate.dialect=org.hibernate.dialect.PostgreSQL95Dialect
datasource.username=hapi_user
datasource.password=password
Here are all errors I get :
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in ca.uhn.fhir.jpa.starter.FhirServerConfigR4: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: HAPI_PU] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation
javax.persistence.PersistenceException: [PersistenceUnit: HAPI_PU] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation
Caused by:
org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation
Caused by:
org.postgresql.util.PSQLException: The column name min_value was not found in this ResultSet.
Last updated: Apr 12 2022 at 19:14 UTC
