Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. 在Oracle中创建一个数据库 schema 并赋予适当的权限; 例如命名为 jwdb (或其它名称) 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;
  2. 下载 jwdb-oracle.sql 并在 "jwdb" schema 运行 SQL 文件. Joget workflow的所有数据表将在 "jwdb" 中被创建.
  3. 在 joget-installation-directory/wflow/目录, 创建一个新的数据库配置文件 - 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.properties, 然后按下面示例1设置(例如数据库 URL, 用户名/密码) .
  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 , 然后按下面示例2将 "oracle"设为当前数据库连接.
  6. Restart重启 Joget Workflow serverWorkflow服务.

...

数据源配置

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.

...

你需要更改 URL, 用户名和密码.

datasource.properties

Code Block
langxml
currentProfile=oracle

...