Install Oracle

From FMR Knowledge Base
Revision as of 08:03, 13 October 2022 by Plazarou (talk | contribs) (Oracle JDBC Driver)
Jump to navigation Jump to search

Overview

Oracle may be used to act as the persistant store for Registry information. However the JDBC driver that communicates from the Registry to an Oracle instance is not provided within FMR and must be obtained by a Systems Administrator.

Obtaining and Specifying the Oracle JDBC Driver

To get FMR to communicate succesfully with an Oracle database, there are three tasks to perform:

  1. Obtain the correct dependency file
  2. Supply this to your Java Web Server (e.g. Tomcat) that you are using to run FMR.
  3. Specify the appropriate Credentials to FMR.


Obtaining the MySql Connector Dependency

To enable FMR and a MySQL database to communicate the depdendency MySQL Connector/J version 8.0.29 (or higher) is required. This is a Jar file of approximately 2.5 Mb in size and called: mysql-connector-java-8.0.29.jar

This jar can be obtained from the MySQL Web site. At the time of writing this article this link will take you to the appropriate page or alternatively you can obtain it from Maven Central.

Obtaining the Jar file from the MySQL website

Driver Requirements

FMR supports the ‘ojdbc8’ Thin JDBC Driver with Java JRE / JDK versions 1.8 or higher.

The driver consists of a single ‘jar’ file: ‘ojdbc8.jar’.

The ‘jar’ file is not included as part of the FMR distribution so must be obtained and installed separately prior to starting the application.

‘ojdbc8.jar’ can be downloaded from Oracle using the following link (accurate at the timne of writing this article). Downlaod Oracle odbc8.jar.

Driver Installation

The ‘ojdbc8.jar’ must be supplied via the Java CLASSPATH.

The recommended option is to add the filesystem location of the ‘ojdbc8.jar’ to the CLASSPATH of the application server. If using Apache Tomcat, this can be done by setting the CLASSPATH environment in the Tomcat ~/bin/setenv.sh script.

For example:

CLASSPATH=/home/oracle/jdbc/ojdbc8.jar

..where /home/oracle/jdbc is the directory containing the ‘ojdbc8.jar’ file.