Setting up the Oracle Database

If you use an Oracle database, the following additional settings must be made:

Using the migration/installation tool with Oracle

Note:

The migration/installation tool must be run even if no migration of an existing X4 BPMS installation is intended.
Before running the migration/installation tool, you must first create an empty database named X4.
To use the migration tool (see Installation Guide, Update Tool section) with Oracle, the Oracle driver must be added to the classpath when starting the tool.
You can find drivers for the corresponding Oracle database under https://www.oracle.com/database/technologies/appdev/jdbc.html.

Providing the driver as a WildFly module

Download the corresponding driver under https://www.oracle.com/database/technologies/appdev/jdbc.html.
Create a WildFly module for the JDBC driver. Therefore, create the folder structure oracle\jdbc\main under X4\Server\wildfly\modules\.
Unpack the JDBC driver (e. g.: ojdbc.jar ) within the folder structure created above.

Create the file module.xml with the following content:

module.xml

XML

<module xmlns="urn:jboss:module:1.5" name="oracle.jdbc"><!-- The namespace urn:jboss:module:1.5 may differ depending on the WildFly version. -->
  <resources>
    <resource-root path="ojdbc.jar"/><!-- Enter the file name of the JDBC driver to be used and which is situated within the specified folder here. -->
  </resources>
  <dependencies>
    <module name="javax.api"/>
    <module name="javax.transaction.api"/>
  </dependencies>
</module>

The oracle.jdbc module is now available.

Registering the driver within the standalone.xml

To use the driver within the datasources, register the driver within the standalone.xml under X4\Server\wildfly\standalone\configuration\:

XML

...
<subsystem xmlns="urn:jboss:domain:datasources:5.0">
  <datasources>
    ...
    <drivers>
	  ... 
      <driver name="oracle" module="oracle.jdbc"><!-- Enter the module name here -->
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      </driver>
    </drivers>
  </datasources>
</subsystem>
...

Configuring the datasources

Configure the Oracle datasources within the standalone.xml under X4\Server\wildfly\standalone\configuration\:

XML

...
<subsystem xmlns="urn:jboss:domain:datasources:5.0">
  <datasources>
    ...
    <datasource jta="false" jndi-name="java:/X4BAM_DS" pool-name="X4BAM_DS" enabled="true" use-java-context="true">
      <connection-url>jdbc:oracle:thin:@localhost:1521/pluggable-database</connection-url><!-- Enter the corresponding Host, Port, SID or Service name here -->
      <driver>oracle</driver><!-- Enter the driver name here -->
      <security user-name="X4SERVER" password="X4"/>
      <statement>
        <prepared-statement-cache-size>32</prepared-statement-cache-size>
      </statement>
	  <!-- In <validation> and <timeout> define settings for automatic reconnection -->	  
	  <validation>
        <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
        <validate-on-match>false</validate-on-match>
        <background-validation>true</background-validation>
        <background-validation-millis>1000</background-validation-millis>
      </validation>
      <timeout>
        <allocation-retry>60</allocation-retry>
        <allocation-retry-wait-millis>1000</allocation-retry-wait-millis>
      </timeout>	
    </datasource>
    <datasource jta="true" jndi-name="java:/PermissionDS" pool-name="PermissionDS" enabled="true" use-java-context="true">    
      <connection-url>jdbc:oracle:thin:@localhost:1521/pluggable-database</connection-url><!-- Enter the corresponding Host, Port, SID or Service name here -->
      <driver>oracle</driver><!-- Enter the driver name here -->
      <security user-name="X4SERVER" password="X4"/>
      <statement>
        <prepared-statement-cache-size>32</prepared-statement-cache-size>
      </statement>
 	  <!-- In <validation> and <timeout> define settings for automatic reconnection -->	  
	  <validation>
        <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
        <validate-on-match>false</validate-on-match>
        <background-validation>true</background-validation>
        <background-validation-millis>1000</background-validation-millis>
      </validation>
      <timeout>
        <allocation-retry>60</allocation-retry>
        <allocation-retry-wait-millis>1000</allocation-retry-wait-millis>
      </timeout>
    </datasource>
    <drivers>
	  ... 
      <driver name="oracle" module="oracle.jdbc"><!-- Enter the module name here -->
        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      </driver>
    </drivers>
  </datasources>
</subsystem>
...