<< Click to Display Table of Contents >> Current:  WorkFlow > Deploy Workflow System  Deploy Workflow System

1.Installation and configuration

①Installing Yonghong products

[Recommend] Installed using the installation package (with built-in process data source) version 851;

* Using the jar upgrade method will cause the built-in case to be unavailable. You need to copy the built-in data source/example/reporting under 851.

② configure biProperties

Workflow is a stand-alone database, supported databases: Mysql, Oracle, Postgresql, Sqlserver

   Note: All databases need to create a new database.

 

2.Mysql

Four parameters are configured in bi.properties:

workflow.datasource.username=xxx

workflow.datasource.driver=com.mysql.jdbc.Driver

workflow.datasource.url=jdbc\:mysql\://ip\:xxx/xxx?characterEncoding\=UTF-8&&autoReconnect\=true&useSSL\=false

workflow.datasource.password=xxx

 

Restart the product and wait for the configuration to install.

If there is still no configuration page after rebooting, please check the log first.

Possible causes: 1 no new database 2 database encoding is correct 3 database itself connection problem 4Mysql is 5.6 (inclusive) or lower version

 

3.Oracle

Create a new user (Oracle creates a new user to create a new table space, the workflow because of the use of open source software liqiubase, the database will be verified at startup):

CREATE USER XXX

IDENTIFIED BY XXX

GRANT CONNECT TO XXX

GRANT RESOURCE TO XXX

Four parameters are configured in bi.properties:

 

workflow.datasource.username=XXX

workflow.datasource.driver=oracle.jdbc.driver.OracleDriver

workflow.datasource.url=jdbc\:oracle\:thin//@ip\:XXX/orcl

workflow.datasource.password=XXX

 

You can also create a table space and specify the size at the same time.

create tablespace uactiviti8

datafile 'uactiviti8.dbf'  

size 50m   --Initial size of the table space, test recommended 50m, production environment 500M

autoextend on; --Automatically expand table space on

CREATE USER uactiviti8

IDENTIFIED BY uactiviti8

DEFAULT TABLESPACE uactiviti8  --The default tablespace must be the same as the username

TEMPORARY TABLESPACE temp; 

 

GRANT CONNECT TO uactiviti8;  

GRANT RESOURCE TO uactiviti8; 

 

4.PostgresSql

‘org.postgresql.jdbc4.Jdbc4Statement.setQueryTimeout(int) is not yet implemented‘This exception is the problem of the driver.

 

Take the postgresql database inside the company as an example. Under the jdk1.8 version, the required drivers are:https://jdbc.postgresql.org/download/postgresql-42.2.5.jar。

After downloading the correct driver, you need to create a new database. The database creation statement is:

CREATE DATABASE activiti

WITH

OWNER = postgres

ENCODING = 'UTF8'

TABLESPACE = pg_default

template = template0

CONNECTION LIMIT = -1;

Four parameters are configured in bi.properties:

workflow.datasource.username=xxx

workflow.datasource.driver=org.postgresql.Driver

workflow.datasource.url=jdbc\:mysql\://ip\:xxx/xxx?characterEncoding\=UTF-8&&autoReconnect\=true&useSSL\=false

workflow.datasource.password=xxx

 

5.Sqlserver

Four parameters are configured in bi.properties:

workflow.datasource.username=xxx

workflow.datasource.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

workflow.datasource.url=jdbc\:sqlserver\://ip\:xxx;databaseName\=xxx

workflow.datasource.password=xxx