Mariadb 数据库适配

流程管理工程配置修改

修改流程管理工程 processAdmin 配置文件

项目工程目录：risenet-y9boot-webapp-processadmin/src/resources/application.yml

修改数据源连接池配置

spring:
    datasource:
        druid:
            filter:
                wall:
                    #关闭Druid防御SQL注入攻击的WallFilter，不然无法操作数据库
                    enabled: false
            y9-public:
                #修改为mariadb驱动类名称
                driver-class-name: org.mariadb.jdbc.Driver 
                #修改为mariadb连接池url
                url: jdbc:mariadb://localhost:3308/y9_public?serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&useUnicode=true&characterEncoding=utf-8&rewriteBatchedStatements=true&useCompression=true&useSSL=false&allowPublicKeyRetrieval=true  
                #修改为在mariadb默认的超级用户
                username: root
                #修改为在mariadb创建的用户密码         
                password: '111111'
            flowable:
                driver-class-name: org.mariadb.jdbc.Driver
                url: jdbc:mariadb://localhost:3308/y9_flowable?serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&useUnicode=true&characterEncoding=utf-8&rewriteBatchedStatements=true&useCompression=true&useSSL=false&allowPublicKeyRetrieval=true 
                username: root         
                password: '111111'
    jpa:
        #修改为mariadb版本对应的方言
        database-platform: org.hibernate.dialect.MariaDB106Dialect
        properties:
            hibernate:
                #修改为mariadb版本对应的方言
                dialect: org.hibernate.dialect.MariaDB106Dialect

事项管理工程配置修改

修改事项管理工程 itemAdmin 配置文件

项目工程目录：risenet-y9boot-webapp-itemadmin/src/resources/application.yml

修改数据源连接池配置

spring:
    datasource:
        druid:
            filter:
                wall:
                    #关闭Druid防御SQL注入攻击的WallFilter，不然无法操作数据库
                    enabled: false
            y9-public:
                #修改为mariadb驱动类名称
                driver-class-name: org.mariadb.jdbc.Driver 
                #修改为mariadb连接池url
                url: jdbc:mariadb://localhost:3308/y9_public?serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&useUnicode=true&characterEncoding=utf-8&rewriteBatchedStatements=true&useCompression=true&useSSL=false&allowPublicKeyRetrieval=true  
                #修改为在mariadb默认的超级用户
                username: root
                #修改为在mariadb创建的用户密码         
                password: '111111'
            flowable:
                driver-class-name: org.mariadb.jdbc.Driver
                url: jdbc:mariadb://localhost:3308/y9_flowable?serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&useUnicode=true&characterEncoding=utf-8&rewriteBatchedStatements=true&useCompression=true&useSSL=false&allowPublicKeyRetrieval=true 
                username: root         
                password: '111111'
    jpa:
        #修改为mariadb版本对应的方言
        database-platform: org.hibernate.dialect.MariaDB106Dialect
        properties:
            hibernate:
                #修改为mariadb版本对应的方言
                dialect: org.hibernate.dialect.MariaDB106Dialect

工作办件工程配置修改

修改工作办件工程 flowableUI 配置文件

项目工程目录：risenet-y9boot-webapp-flowableui-position/src/resources/application.yml

修改数据源连接池配置

spring:
    datasource:
        druid:
            filter:
                wall:
                    #关闭Druid防御SQL注入攻击的WallFilter，不然无法操作数据库
                    enabled: false
            y9-public:
                #修改为mariadb驱动类名称
                driver-class-name: org.mariadb.jdbc.Driver 
                #修改为mariadb连接池url
                url: jdbc:mariadb://localhost:3308/y9_public?serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&useUnicode=true&characterEncoding=utf-8&rewriteBatchedStatements=true&useCompression=true&useSSL=false&allowPublicKeyRetrieval=true  
                #修改为在mariadb默认的超级用户
                username: root
                #修改为在mariadb创建的用户密码         
                password: '111111'
    jpa:
        #修改为mariadb版本对应的方言
        database-platform: org.hibernate.dialect.MariaDB106Dialect
        properties:
            hibernate:
                #修改为mariadb版本对应的方言
                dialect: org.hibernate.dialect.MariaDB106Dialect