Oracle database drivers and configurations

In addition to the following recommendations, be sure and follow vendor documentation for driver installation best practices.

Component Supported driver version Notes
Web application

11.2.0.4  (ojdbc6.jar)
12.2.0.1 (ojdbc8.jar)

Type the following from a command line as the jive user:

jive set webapp.custom_ld_library_path_additions path/to/driver
jive set webapp.custom_classpath_additions path/to/your_JDBC_Driver.jar

where path/to/driver is the path to the Oracle JDBC driver and your_JDBC_Driver.jar is the name of the JAR file.
Activity Engine

11.2.0.4  (ojdbc6.jar)
12.2.0.1 (ojdbc8.jar)

Type the following from a command line as the jive user:

jive set eae.custom_ld_library_path_additions path/to/driver
jive set eae.custom_classpath_additions path/to/your_JDBC_Driver.jar

where path/to/driver is the path to the Oracle JDBC driver and your_JDBC_Driver.jar is the name of the JAR file.

Additional configuration for Oracle 11gR2, 12, 19

Customers using Oracle 11gR2, 12, 19 need to add a fetchSizeSupported entry in the database element of the jive_startup.xml file as shown: 

<jive>
      <setup>true</setup>
      <temp/>
      <locale>
        <characterEncoding>UTF-8</characterEncoding>
      </locale>
      <database>
        <defaultProvider>
          <password encrypted="true"/>
          <connectionTimeout>60</connectionTimeout>
          <maxConnections>50</maxConnections>
          <username>username</username>
          <driver>oracle.jdbc.driver.OracleDriver</driver>
          <minConnections>25</minConnections>
          <serverURL>jdbc:oracle:oci:@host:1521/db</serverURL>
        </defaultProvider>
        <fetchSizeSupported>false</fetchSizeSupported>
      </database>
      <connectionProvider>
        <className>com.jivesoftware.base.database.DefaultConnectionProvider</className>
      </connectionProvider>
    </jive>

Required libraries for RHEL7

Note that distributions based on RHEL7 do not always install libaio.so by default. This library is required to use the Oracle driver. On app servers running Red Hat 7 or CentOS 7 that use Oracle as a database, make sure to run the following command: 

 # apt-get update && apt-get install libaio1</codeblock>