server: port: 31000 logging: level: root: info org.flowable.engine.impl.persistence.entity.*: debug org.flowable.task.service.impl.persistence.entity.*: debug # 注意: # 若使用 Oracle 或 达梦 数据库必需配置模式名称 # 若使用 PostgreSQL 和 人大金仓KingbaseES 数据库, 默认public模式无需配置模式名称, 若指定模式需要配置模式名称 # 若使用 MySQL 和 SQLServer 无需配置模式名称 #flowable: # database-schema: JNPF_FLOW # ===================== 1 若使用MySQL数据库-Start ===================== spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver type: com.mysql.cj.jdbc.MysqlDataSource url: jdbc:mysql://usky-cloud-mysql:3306/jnpf_flow?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&autoReconnect=true&nullCatalogMeansCurrent=true username: root password: yt123456 # ===================== 1 若使用MySQL数据库-End ======================= # ===================== 2 若使用SQLServer数据库-Start ===================== #spring: # datasource: # driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver # type: com.microsoft.sqlserver.jdbc.SQLServerDataSource # url: jdbc:sqlserver://127.0.0.1:1433;databaseName=jnpf_flow;trustServerCertificate=true # username: sa # password: 123456 # ===================== 2 若使用SQLServer数据库-End ======================= # ===================== 3 若使用Oracle数据库-Start ===================== #flowable: # database-schema: JNPF_FLOW #spring: # datasource: # driver-class-name: oracle.jdbc.OracleDriver # type: oracle.jdbc.datasource.impl.OracleDataSource # url: jdbc:oracle:thin:@127.0.0.1:1521:ORCL # username: JNPF_FLOW # password: dbpasswd # ===================== 3 若使用Oracle数据库-End ======================= # ===================== 4 若使用PostgreSQL数据库-Start ===================== # ========== 4.1 若使用默认public模式-Start ========== #spring: # datasource: # driver-class-name: org.postgresql.Driver # type: org.postgresql.ds.PGSimpleDataSource # url: jdbc:postgresql://127.0.0.1:5432/jnpf_flow # username: dbuser # password: dbpasswd # ========== 4.1 若使用默认public模式-End ========== # ========== 4.2 若使用其他模式-Start ========== #flowable: # database-schema: jnpf_flow #spring: # datasource: # driver-class-name: org.postgresql.Driver # type: org.postgresql.ds.PGSimpleDataSource # url: jdbc:postgresql://127.0.0.1:5432/jnpf_flow # username: dbuser # password: dbpasswd # ========== 4.2 若使用其他模式-End ========== # ===================== 4 若使用PostgreSQL数据库-End ======================= # ===================== 5 若使用达梦dm8数据库-Start ===================== #flowable: # database-schema: JNPF_FLOW #spring: # datasource: # driver-class-name: dm.jdbc.driver.DmDriver # type: dm.jdbc.driver.DmdbDataSource # # 连接后面需要添加参数 ?compatibleMode=oracle # url: jdbc:dm://127.0.0.1:5236/JNPF_FLOW?compatibleMode=oracle # username: dbuser # password: dbpasswd # ===================== 5 若使用达梦dm8数据库-End ======================= # ===================== 6 若使用人大金仓KingbaseES数据库-Start ===================== # ========== 6.1 若使用默认public模式-Start ========== #spring: # datasource: # driver-class-name: org.postgresql.Driver # type: org.postgresql.ds.PGSimpleDataSource # url: jdbc:postgresql://127.0.0.1:5432/jnpf_flow # username: dbuser # password: dbpasswd # ========== 6.1 若使用默认public模式-End ========== # ========== 6.2 若使用其他模式-Start ========== #flowable: # database-schema: jnpf_flow #spring: # datasource: # driver-class-name: org.postgresql.Driver # type: org.postgresql.ds.PGSimpleDataSource # url: jdbc:postgresql://127.0.0.1:5432/jnpf_flow # username: dbuser # password: dbpasswd # ========== 6.2 若使用其他模式-End ========== # ===================== 6 若使用人大金仓KingbaseES数据库-End =======================