Difference between revisions of "Oracle database connection"

From Fusion Registry Wiki
Jump to navigation Jump to search
(Installing the JDBC Driver)
(JDBC Drivers)
Line 8: Line 8:
 
Fusion software does not ship with the Oracle JDBC drivers for licensing reasons. The correct driver for your Oracle database release and Java version can be downloaded from [https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html Oracle].
 
Fusion software does not ship with the Oracle JDBC drivers for licensing reasons. The correct driver for your Oracle database release and Java version can be downloaded from [https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html Oracle].
  
In general, use ojdbc8.jar for Java 8,9 or 11. Use ojdbc10.jar for Java 10.
+
In general, use <code>ojdbc8.jar</code> for Java 8,9 or 11, and <code>ojdbc10.jar </code> for Java 10.
  
 
=Installing the JDBC Driver=
 
=Installing the JDBC Driver=

Revision as of 11:06, 14 January 2021

Overview

Fusion Registry Core supports Oracle for both its main operating database and as a Data Source.

Oracle 11g, 12c, 18c and 19c are supported.

JDBC Drivers

Fusion software does not ship with the Oracle JDBC drivers for licensing reasons. The correct driver for your Oracle database release and Java version can be downloaded from Oracle.

In general, use ojdbc8.jar for Java 8,9 or 11, and ojdbc10.jar for Java 10.

Installing the JDBC Driver

The driver jar needs to be copied to a suitable location on the machine running Fusion Registry. For instance:

c:\oracle\ojdbc8.jar

And needs to be explicitly added to the CLASSPATH. In Tomcat, this can be done in the Tomcat setenv file.

Configuring the Oracle Database Connection

Operating Database