Oracle¶
Installing the Oracle connector¶
FMR needs the Oracle JDBC thin driver to connect to an Oracle database.
FMR supports the ojdbc17 JDBC driver with Java JDK 17.
The driver is supplied as a single jar file named ojdbc17.jar. It is not included with the FMR distribution, so it must be downloaded and installed separately before starting the application.
Download ojdbc17.jar from Oracle: Oracle JDBC Downloads.
The ojdbc17.jar file must be made available to the application server, either by copying it into the FMR Tomcat deployment WEB-INF/lib directory or by adding its location to the Java CLASSPATH.
Locate the Tomcat directory and copy ojdbc17.jar into tomcat/webapps/ROOT/WEB-INF/lib.
Create a suitable directory and copy in ojdbc17.jar. For example /usr/local/lib/ojdbc17.jar.
Refer to the Setting JAVA_OPTS and CLASSPATH environment variables page for guidance on adding the jar location to the Java CLASSPATH.
Connection Details¶
| Parameter | Value |
|---|---|
| Default port | 1521 |
| Connection String | jdbc:oracle:thin:@//[serverName][:portNumber]/[serviceName] |
| Class Name | oracle.jdbc.OracleDriver |
Use the Oracle JDBC Thin driver with a service name in the connection URL. For example:
jdbc:oracle:thin:@//dbhost.example.com:1521/fmrprd
If no port is specified, Oracle uses the default listener port 1521.