Difference between revisions of "Install Oracle"
(→Driver Installation) |
(→Overview) |
||
| Line 2: | Line 2: | ||
[[Category:How_To V11]] | [[Category:How_To V11]] | ||
=Overview= | =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. | |
| − | |||
| − | |||
= Oracle JDBC Driver = | = Oracle JDBC Driver = | ||
Revision as of 07:59, 13 October 2022
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.
Oracle JDBC Driver
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.
