多数据库支持

AgileBPM在数据库类型上支持 MySQL、Oracle、人大金仓、PostgreSQL。

MySQL

创建数据库

mysql> CREATE DATABASE agilebpm_5 DEAFULT CHARACTER SET utf8mb4;

执行初始化脚本

脚本路径：agile-bpm/doc/sql/mysql/full/agilebpm_full.sql

引入依赖

文件路径：agile-bpm/ab-spring-boot/ab-spring-boot-app/pom.xml

xml

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

配置数据源

文件路径：agile-bpm/ab-spring-boot/ab-spring-boot-app/src/main/resources/application.yml

yaml

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://192.168.1.100:3306/agilebpm_5?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false&serverTimezone=Asia/Shanghai
    username: root
    password: root

Oracle

INFO

AgileBPM版本：5.5.0+
数据库：11g

创建AgileBPM表空间和连接用户

shell

> CREATE TABLESPACE agilebpm_5 LOGGING DATAFILE 'agilebpm_5.dbf' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 20880M EXTENT MANAGEMENT LOCAL;
> CREATE TEMPORARY TABLESPACE agilebpm_5_temp TEMPFILE 'agilebpm_5_temp.dbf' SIZE 100m AUTOEXTEND ON NEXT 32m MAXSIZE 20880m EXTENT MANAGEMENT LOCAL;

> CREATE USER a5 IDENTIFIED BY 12345678 DEFAULT TABLESPACE agilebpm_5 TEMPORARY TABLESPACE agilebpm_5_temp;
> GRANT create session,resource TO a5;

执行初始化脚本

脚本路径：agile-bpm/doc/sql/oracle/full/agilebpm_full.sql

引入依赖

agile-bpm/ab-spring-boot/ab-spring-boot-app/pom.xml

xml

<dependency>
    <groupId>com.oracle.database.nls</groupId>
    <artifactId>orai18n</artifactId>
</dependency>
<dependency>
    <groupId>com.oracle.database.jdbc</groupId>
    <artifactId>ojdbc8</artifactId>
</dependency>

数据源连接配置

文件路径：agile-bpm/ab-spring-boot/ab-spring-boot-app/src/main/resources/application.yml

spring:
  datasource:
     driver-class-name: oracle.jdbc.driver.OracleDriver
     url: jdbc:oracle:thin:@192.168.1.100:1521:ORCL
     username: a5
     password: 12345678

人大金仓

INFO

AgileBPM版本：5.5.0+
数据库：KingbaseES V8

创建数据库

> CREATE DATABASE agilebpm_5 WITH OWNER = "system" ENCODING UTF8;

执行初始化脚本

因人大金仓在兼容模式上有Oracle和PostgreSQL，请根据兼容模式来执行对应初始化脚本

Oracle

脚本路径：agile-bpm/doc/sql/oracle/full/agilebpm_full.sql

PostgreSQL

脚本路径：agile-bpm/doc/sql/postgres/full/agilebpm_full.sql

引入依赖

文件路径：agile-bpm/ab-spring-boot/ab-spring-boot-app/pom.xml

xml

<dependency>
    <groupId>cn.com.kingbase</groupId>
    <artifactId>kingbase8</artifactId>
    <version>8.6.0</version>
</dependency>

配置数据源

文件路径：agile-bpm/ab-spring-boot/ab-spring-boot-app/src/main/resources/application.yml

yaml

spring:
  datasource:
    driver-class-name: com.kingbase8.Driver
    url: jdbc:kingbase8://192.168.1.100:54321/agilebpm_5
    username: system
    password: system

PostgreSQL

INFO

AgileBPM版本：5.5.0+

创建数据库

> CREATE DATABASE agilebpm_5;

执行初始化脚本

脚本路径：agile-bpm/doc/sql/postgres/full/agilebpm_full.sql

引入依赖

文件路径：agile-bpm/ab-spring-boot/ab-spring-boot-app/pom.xml

xml

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
</dependency>

配置数据源

文件路径：agile-bpm/ab-spring-boot/ab-spring-boot-app/src/main/resources/application.yml

yaml

spring:
  datasource:
     driver-class-name: org.postgresql.Driver
     url: jdbc:postgresql://192.168.1.100:5432/agilebpm_5
     username: postgres
     password: postgres

多数据库支持 #

MySQL #

Oracle #

人大金仓 #

PostgreSQL #

多数据库支持

MySQL

Oracle

人大金仓

PostgreSQL