A project to rapidly store some OpenICE data in an Oracle database.

In the lab we are using Oracle Database Express Edition 11g Release 2.

We converted the RedHat package for use on an Ubuntu server following these instructions.

For an Oracle client we are using the free Oracle SQL Developer.

1. Clone or download this repository. To download, click the "Download ZIP" button above. If you download the ZIP, the directory sturctures listed below will be /oracle-openice-master/ instead of /oracle-openice/.

2. You must have the Oracle JDBC "thin" driver available. Download this yourself from here to ensure you agree to the terms of Oracle's licensing. Unfortunately we are not allowed to re-distribute this driver ourselves; you must acquire it from Oracle directly.

3. You must have Apache Maven installed. Use your package manager of choice or download the .bin.zip directly from Apache.

4. To add the oracle driver to a local Maven repo:

   mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.3 -Dpackaging=jar -Dfile=<Path where the jar is, example downloads>/ojdbc6.jar -DgeneratePom=true

   On Windows, be sure to not include spaces in your directory path. E.g. C:\Progra~1\... instead of C:\Program Files\...

5. Create a configuration file .config containing configuration information.

   # Example Configuration
   # DDS Domain Identifier
   domain=15
   # oracle JDBC connection string
   url=jdbc:oracle:thin:@127.0.0.1:1521/XE
   # oracle username
   user=openice
   # oracle password
   pass=openice
   # DDS Partition information
   partition=MRN=14cd923b336

6. Generate an SQL Schema

   ./gradlew schemaGen

   On Windows:

   gradlew schemaGen

   This will create a file called schema.sql which you must apply to our oracle database.

   For convenience, we have also been committing the schema to the repo at schema.sql.

7. Create a local installation of the software

   ./gradlew installDist

   On Windows:

   gradlew installDist

8. Run the software from your local installation

   build/install/oracle-openice/bin/oracle-openice

   On Windows:

   build\install\oracle-openice-master\bin\oracle-openice

9. Send SIGINT (Ctrl-C) when you would like to exit