How connect HAPI-FHIR with Oracle database.

[Felipe Henríquez]

Dear I've installed HAPI-FHIR in CentOS 7.5.1804. I have HAPI-FHIR JPA up and running with Apache Tomcat latest, builded with Maven latest, but I want to use my own database, Oracle 12c.

I've readed the documentation and says that the file FhirServerConfig.java need to be modified, but exist two of these files:

Locate command show the following

/src/main/java/ca/uhn/fhir/jpa/demo/FhirServerConfig.java

/src/main/java/ca/uhn/fhir/jpa/demo/elasticsearch/FhirServerConfig.java

Is necessary modify both files?

And my other doubt is how can I configure the following section for Oracle 12c

public DataSource dataSource() {

                  BasicDataSource retVal = new BasicDataSource();

                  retVal.setDriver(new org.apache.derby.jdbc.EmbeddedDriver());

                  retVal.setUrl("jdbc:derby:directory:target/jpaserver_derby_files;create=true");

                  retVal.setUsername("");

                  retVal.setPassword("");

                  return retVal;

          }

And in what part I must to import the Oracle driver?

Thanks in advance!.

[Felipe Henríquez]

Anyone knows how to do this?, thanks.

[Patrick Werner]

Am Mittwoch, 29. August 2018 16:11:12 UTC+2 schrieb Felipe Henríquez:

Locate command show the following

/src/main/java/ca/uhn/fhir/jpa/demo/FhirServerConfig.java

/src/main/java/ca/uhn/fhir/jpa/demo/elasticsearch/FhirServerConfig.java

If you want the example server with Oracle and default Lucene Index you only have to modify FhirServerConfig.java (everything under elasticsearch isn't loaded on startup by default, have a look at the web.xml

Is necessary modify both files?

And my other doubt is how can I configure the following section for Oracle 12c

public DataSource dataSource() {

                  BasicDataSource retVal = new BasicDataSource();

                  retVal.setDriver(new org.apache.derby.jdbc.EmbeddedDriver());

                  retVal.setUrl("jdbc:derby:directory:target/jpaserver_derby_files;create=true");

                  retVal.setUsername("");

                  retVal.setPassword("");

                  return retVal;

          }

And in what part I must to import the Oracle driver?

Oracle JDBC driver should be imported via maven, and you have to config the hibernate properties, some guidance on that is contained here:

https://www.mkyong.com/hibernate/maven-3-hibernate-3-6-oracle-11g-example-xml-mapping/

[Felipe Henríquez]

Thanks for your help I have some doubts still, ¿how do you load the structure of database in Oracle database?, there aren't any init script for HAPI-FHIR oracle database.

[James Agnew]

Hapi fhir will initialize the DB on startup in it's default configuration. You don't need to run any init scripts.

Cheers,

James

sent from my phone.

On Wed, Nov 7, 2018, 08:43 Felipe Henríquez <fahenr...@gmail.com wrote:

Thanks for your help I have some doubts still, ¿how do you load the structure of database in Oracle database?, there aren't any init script for HAPI-FHIR oracle database.

--
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 post to this group, send email to hapi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/hapi-fhir/65ce8976-d025-4d0a-8204-1f74d3f96efe%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.