HAPI-FHIR MySQL Schema

[Yi Luo]

Hi. I have deployed DSTU2 server using MySQL. Three questions:

1. I can create patient using resuful api and the uploaded patient can be searched using resuful api, too. However, ever time I restart the server, all the patient resources are gone.
2. MySQL database is totally empty, how can I create the schema? Automatically or manually?
3. As I noticed that the actual resources are stored in files rather than in MySQL. So, how can I config where to store the resource files?

Many thanks.

[kevin.m...@xml-solutions.com]

Are you using the JPA Server? It sounds like your dao/jpa config isn't correct

[Yi Luo]

Yes. I am using JPA. Do you mean if corrected configured, JPA will create the schema automatically?

[kevin.m...@xml-solutions.com]

You should have a FHIRConfig class. One I've modified can be found here (using MySQL)

https://github.com/KevinMayfield/FHIRTest/blob/master/Demo-Server-Stu3/src/main/java/uk/nhs/careConnect/stu3/ServerConfig/FhirServerConfig.java

The first three beans sort out the database connection and configuring jpa/hibernate (and lucene)

On Saturday, 1 April 2017 06:49:48 UTC+1, Yi Luo wrote:

[Yi Luo]

Thank you so much. Everything's working now.

[Sandeep Savarala]

Hi,

Following up here. So will JPA automatically create the schema in MySql with us doing anything?

Thanks

[Prateek Patil]

Yes 
Please refer this(https://github.com/hapifhir/hapi-fhir-jpaserver-starter#mysql-configuration) for configuration.

Cheers
Prateek

--
You received this message because you are subscribed to the Google Groups "HAPI FHIR" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hapi-fhir+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/hapi-fhir/6070d17b-231e-43ed-92fc-46d4c97d9ec4%40googlegroups.com.