Page History

We have tested Joget Workflow v3 with Oracle 10g Express, and generally it ran fine. However, if you have found any issue, please feel free to inform the community through forum discussion.

1. Create a database schema in Oracle

   , name it as 

   with the appropriate permissions; name it jwdb (or

   other

   another preferred name) e.

   g. 

   Code Block
   language sql
   CREATE USER jwdb IDENTIFIED BY jwdb; GRANT connect, resource TO jwdb; GRANT create session TO jwdb; GRANT create table TO jwdb;

2. Download jwdb-Download jwdb_oracle.sql, and load this SQL file to "jwdb" schema. This will populate all necessary Joget Workflow table structure 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, and 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 to as shown in Figure 2 below. This is to activate the datasource profile named "oracle".
6. Restart Joget Workflow server.

...

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.

...