Create a database schema in Oracle with the appropriate permissions; name it 在Oracle中创建一个数据库 schema 并赋予适当的权限; 例如命名为 jwdb (or another preferred name或其它名称) e.g.
| Code Block |
|---|
|
CREATE USER jwdb IDENTIFIED BY jwdb;
GRANT connect, resource TO jwdb;
GRANT create session TO jwdb;
GRANT create table TO jwdb; |
- Download 下载 jwdb-oracle.sql and load this SQL file to 并在 "jwdb" schema. This will populate all necessary Joget Workflow table structures into schema 运行 SQL 文件. Joget workflow的所有数据表将在 "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, 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.
- 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.
| Code Block |
|---|
|
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.
| Code Block |
|---|
|
currentProfile=oracle |
...