Stream: hapi
Topic: Can we specify db schema?
Keerthivasan Ramanathan (Sep 28 2020 at 13:43):
Hi, we are able to run the hapi fhir server in the default db schema 'public' . but, we are not able to setup in a different schema of the database. How do we approach this?
@James Agnew @Jens Villadsen
James Agnew (Sep 28 2020 at 13:52):
This is typically done via the JDBC URL although the exact syuntax is databasse specific. Here's how for Postgres for example: https://turreta.com/2015/03/01/how-to-specify-a-default-schema-when-connecting-to-postgresql-using-jdbc/
Keerthivasan Ramanathan (Sep 29 2020 at 05:03):
Thank you so much @James Agnew I'll check this out!
Keerthivasan Ramanathan (Sep 29 2020 at 06:39):
Its working well. The tables are getting generated into the provided schema. but, I see the sequences are not getting generated in the provided schema in 'postgres'. I think it need some code changes to set the provided schema before executing the create sequence instructions. Let me know your views. Thanks again for the guidance. you saved my day!
Last updated: Apr 12 2022 at 19:14 UTC
