Difference between revisions of "Oracle database connection"
(→Overview) |
|||
(13 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
[[Category:How_To]] | [[Category:How_To]] | ||
+ | [[Category:Fusion Registry Install]] | ||
=Overview= | =Overview= | ||
Fusion Registry Core supports Oracle for both its main operating database and as an Externally Managed Data Source.<br> | Fusion Registry Core supports Oracle for both its main operating database and as an Externally Managed Data Source.<br> | ||
[[File:Warning.PNG|30px]] Oracle is not supported as a Registry Managed Data Source. | [[File:Warning.PNG|30px]] Oracle is not supported as a Registry Managed Data Source. | ||
− | Oracle 11g | + | Compatibility |
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! Oracle Release | ||
+ | |- | ||
+ | | Oracle database 11g | ||
+ | |- | ||
+ | | Oracle database 12c | ||
+ | |- | ||
+ | | Oracle database 18c | ||
+ | |- | ||
+ | | Oracle database 19c | ||
+ | |} | ||
=JDBC Drivers= | =JDBC Drivers= | ||
Line 22: | Line 35: | ||
====Simple Configuration==== | ====Simple Configuration==== | ||
− | [[File:OracleOperatingSimple.PNG| | + | [[File:OracleOperatingSimple.PNG|thumb]] |
Database Type: Oracle | Database Type: Oracle | ||
− | Server: | + | Server: The hostname or IP address of the Oracle database server |
− | Port: | + | Port: The Oracle service port number - usually 1521 |
− | Schema: | + | Schema: The Oracle 'service name' |
− | UserId: | + | UserId: The id of a pre-existing Oracle user with sufficient privileges to create and delete tables, and insert, update and delete data |
− | Password: | + | Password: The password for the Oracle UserId |
====Advanced Configuration==== | ====Advanced Configuration==== | ||
The advanced configuration option provides additional control over the connection by allowing an explicit Connection String to be defined. | The advanced configuration option provides additional control over the connection by allowing an explicit Connection String to be defined. | ||
− | [[File:OracleOperatingAdvanced.PNG| | + | [[File:OracleOperatingAdvanced.PNG|thumb]] |
Database Type: Custom | Database Type: Custom | ||
Database Connection String: jdbc:oracle:thin:<hostname>:<port>/<service name> | Database Connection String: jdbc:oracle:thin:<hostname>:<port>/<service name> | ||
Line 42: | Line 55: | ||
Password: The password for the Oracle UserId | Password: The password for the Oracle UserId | ||
− | ==Configuring an Oracle Data Source== | + | ==Configuring an Externally Managed Oracle Data Source== |
Data Sources are configured in the Data Sources Manager - choose 'Data Manager' from the left-hand menu bar. | Data Sources are configured in the Data Sources Manager - choose 'Data Manager' from the left-hand menu bar. | ||
+ | ====Simple Configuration==== | ||
+ | [[File:OracleDataSourceSimple.PNG|thumb]] | ||
+ | Connection Id: A unique ID for the connection [A-Za-z0-9_]+ | ||
+ | Connection Type: Externally Managed | ||
+ | Database Cache: None - No caching | ||
+ | Fusion Store - The data is replicated to the built-in in-memory database for additional query performance, but may require additional memory | ||
+ | Database Platform: Oracle | ||
+ | Connection Settings: Simple | ||
+ | Server: The hostname or IP address of the Oracle database server | ||
+ | Port: The Oracle service port number - usually 1521 | ||
+ | Schema: The Oracle 'service name' | ||
+ | Username: The id of a pre-existing Oracle user with sufficient privileges to create and delete tables, and insert, update and delete data | ||
+ | Password: The password for the Oracle UserId | ||
====Advanced Configuration==== | ====Advanced Configuration==== | ||
− | [[File:OracleDataSourceAdvanced.PNG| | + | [[File:OracleDataSourceAdvanced.PNG|thumb]] |
+ | Connection Id: A unique ID for the connection [A-Za-z0-9_]+ | ||
+ | Connection Type: Externally Managed | ||
+ | Database Cache: None - No caching | ||
+ | Fusion Store - The data is replicated to the built-in in-memory database for additional query performance, but may require additional memory | ||
+ | Database Platform: Oracle | ||
+ | Connection Settings: Advanced | ||
+ | DB Connection String: jdbc:oracle:thin:<hostname>:<port>/<service name> | ||
+ | Other options can be added to the Connection String is required - refer to the Oracle JDBC documentation for details | ||
+ | Dialect: org.hibernate.dialect.Oracle10gDialect or org.hibernate.dialect.Oracle12cDialect | ||
+ | Driver Class Name: oracle.jdbc.driver.OracleDriver | ||
+ | Database Username: The id of a pre-existing Oracle user with sufficient privileges to create and delete tables, and insert, update and delete data | ||
+ | Database Password: The password for the Oracle UserId |
Latest revision as of 08:50, 4 September 2023
Contents
Overview
Fusion Registry Core supports Oracle for both its main operating database and as an Externally Managed Data Source.
Oracle is not supported as a Registry Managed Data Source.
Compatibility
Oracle Release |
---|
Oracle database 11g |
Oracle database 12c |
Oracle database 18c |
Oracle database 19c |
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
Configure the operating database connection either on first install of the Fusion Registry Core webapp, or in service when to need to change to a different database.
Simple Configuration
Database Type: Oracle Server: The hostname or IP address of the Oracle database server Port: The Oracle service port number - usually 1521 Schema: The Oracle 'service name' UserId: The id of a pre-existing Oracle user with sufficient privileges to create and delete tables, and insert, update and delete data Password: The password for the Oracle UserId
Advanced Configuration
The advanced configuration option provides additional control over the connection by allowing an explicit Connection String to be defined.
Database Type: Custom Database Connection String: jdbc:oracle:thin:<hostname>:<port>/<service name> Other options can be added to the Connection String is required - refer to the Oracle JDBC documentation for details Dialect: org.hibernate.dialect.Oracle10gDialect or org.hibernate.dialect.Oracle12cDialect Driver Class Name: oracle.jdbc.driver.OracleDriver UserId: The id of a pre-existing Oracle user with sufficient privileges to create and delete tables, and insert, update and delete data Password: The password for the Oracle UserId
Configuring an Externally Managed Oracle Data Source
Data Sources are configured in the Data Sources Manager - choose 'Data Manager' from the left-hand menu bar.
Simple Configuration
Connection Id: A unique ID for the connection [A-Za-z0-9_]+ Connection Type: Externally Managed Database Cache: None - No caching Fusion Store - The data is replicated to the built-in in-memory database for additional query performance, but may require additional memory Database Platform: Oracle Connection Settings: Simple Server: The hostname or IP address of the Oracle database server Port: The Oracle service port number - usually 1521 Schema: The Oracle 'service name' Username: The id of a pre-existing Oracle user with sufficient privileges to create and delete tables, and insert, update and delete data Password: The password for the Oracle UserId
Advanced Configuration
Connection Id: A unique ID for the connection [A-Za-z0-9_]+ Connection Type: Externally Managed Database Cache: None - No caching Fusion Store - The data is replicated to the built-in in-memory database for additional query performance, but may require additional memory Database Platform: Oracle Connection Settings: Advanced DB Connection String: jdbc:oracle:thin:<hostname>:<port>/<service name> Other options can be added to the Connection String is required - refer to the Oracle JDBC documentation for details Dialect: org.hibernate.dialect.Oracle10gDialect or org.hibernate.dialect.Oracle12cDialect Driver Class Name: oracle.jdbc.driver.OracleDriver Database Username: The id of a pre-existing Oracle user with sufficient privileges to create and delete tables, and insert, update and delete data Database Password: The password for the Oracle UserId