...
- Create a database schema in Oracle; name it jwdb (or other preferred name).
- Download jwdb-oracle.sql, and and load this SQL file to "jwdb" schema. This will populate all necessary Joget Workflow table structures into "jwdb".
- In joget-installation-directory/wflow/, create a new datasource profile file - app_datasource-oracle.properties.
- Open to edit joget-installation-directory/wflow/app_datasource-oracle.properties in text editor, and 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.
- 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".
- Restart Joget Workflow server.
...
{"serverDuration": 110, "requestCorrelationId": "48d4d180bb1ac8b1"}