Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. Create a database schema in Oracle with the appropriate permissions; name it jwdb (or another preferred name) e.g. 

    Code Block
    languagesql
    CREATE USER jwdb IDENTIFIED BY jwdb;
    GRANT connect, resource TO jwdb;
    GRANT create session TO jwdb;
    GRANT create table TO jwdb;
     
    GRANT UNLIMITED TABLESPACE TO jwdb;
  2. Download jwdb-oracle-ddl.sql and load this SQL file to "jwdb" schema. This will populate all necessary Joget Workflow table structures into "jwdb".
  3. In joget-installation-directory/wflow/, create a new datasource profile file - app_datasource-oracle.properties.
  4. Open to edit joget-installation-directory/wflow/app_datasource-oracle.properties in text editor, then insert contents as shown in Figure 1 below. You may need to edit the configurations (such as datasource URL, database user/password) according to your environment.
  5. Open to edit joget-installation-directory/wflow/app_datasource.properties in text editor, and change the content as shown in Figure 2 below. This is to activate the datasource profile named "oracle".
  6. Restart Joget Workflow server.

Figure 1: Datasource Profile Configurations

Code Block
langxml
workflowUser=jwdb
workflowPassword=jwdb
workflowDriver=oracle.jdbc.driver.OracleDriver
workflowUrl=jdbc\:oracle\:thin\:@hostname\:1521\:XE

You may need to change the datasource URL, database user and database user's password accordingly.

Figure 2: datasource.properties

Code Block
langxml
currentProfile=oracle