guns-flowable 代码模块迁移到 jeecg 所遇问题记录

Sky清風

已于 2022-04-27 17:30:42 修改

阅读量446

点赞数

分类专栏：笔记文章标签： springboot

于 2022-04-27 17:29:39 首次发布

本文链接：https://blog.csdn.net/qq1461855809/article/details/124432474

版权

笔记专栏收录该内容

6 篇文章 0 订阅

订阅专栏

flowable模块服务启动后，无法通过网关访问，一直提示401 Unauthorized，并且后台flow模块界面访问会自动调用 http://172.18.4.130:7009/login flowable 原生登录接口

解决：由于我要使用jeecg Security 所以我这里直接在启动类上直接忽略即可。

@SpringBootApplication(scanBasePackages = {"org.jeecg"},exclude = {SecurityAutoConfiguration.class,
ManagementWebSecurityAutoConfiguration.class})

启动flowable 模块报错：version mismatch: library version is '6.5.0.6', db version is 6.7.2.1

解决：修改ACT_GE_PROPERTY 对应的版本号

模型管理-新建模型报错

nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'prefix' in 'class org.flowable.ui.modeler.domain.Model'

Handler dispatch failed; nested exception is java.lang.NoClassDefFoundError: Could not initialize class org.jeecg.modular.definition.factory.FlowableDefinitionFactory

上述全是表结构问题导致的，从新执行sql即可。

act 开头表先全部删除，然后执行flowable 原始sql

https://github.com/flowable/flowable-engine/blob/main/distro/sql/create/all/flowable.oracle.all.create.sql

新建模型还是报错的话，执行对应的表，例如我是act_de_model报错：

CREATE TABLE act_de_model(
    id VARCHAR2(255) NOT NULL,
    name VARCHAR2(400) NOT NULL,
    model_key VARCHAR2(400) NOT NULL,
    description VARCHAR2(4000),
    model_comment VARCHAR2(4000),
    created DATE,
    created_by VARCHAR2(255),
    last_updated DATE,
    last_updated_by VARCHAR2(255),
    version NUMBER(11),
    model_editor_json clob,
    thumbnail blob,
    model_type NUMBER(11),
    tenant_id VARCHAR2(255),
    PRIMARY KEY (id)
);

COMMENT ON TABLE act_de_model IS '';



-- CREATE UNIQUE INDEX PRIMARY ON act_de_model(id);
CREATE INDEX idx_proc_mod_created ON act_de_model(created_by);

CREATE TABLE act_de_model_history(
    id VARCHAR2(255) NOT NULL,
    name VARCHAR2(400) NOT NULL,
    model_key VARCHAR2(400) NOT NULL,
    description VARCHAR2(4000),
    model_comment VARCHAR2(4000),
    created DATE,
    created_by VARCHAR2(255),
    last_updated DATE,
    last_updated_by VARCHAR2(255),
    removal_date DATE,
    version NUMBER(11),
    model_editor_json blob,
    model_id VARCHAR2(255) NOT NULL,
    model_type NUMBER(11),
    tenant_id VARCHAR2(255),
    PRIMARY KEY (id)
);

COMMENT ON TABLE act_de_model_history IS '';




-- CREATE UNIQUE INDEX PRIMARY ON act_de_model_history(id);
CREATE INDEX idx_proc_mod_history_proc ON act_de_model_history(model_id);



CREATE TABLE act_de_model_relation(
    id VARCHAR2(255) NOT NULL,
    parent_model_id VARCHAR2(255),
    model_id VARCHAR2(255),
    relation_type VARCHAR2(255),
    PRIMARY KEY (id),
		CONSTRAINT act_de_model_relation_ibfk_1 FOREIGN KEY (model_id) REFERENCES act_de_model(id),
		CONSTRAINT act_de_model_relation_ibfk_2 FOREIGN KEY (parent_model_id) REFERENCES act_de_model(id)
);

COMMENT ON TABLE act_de_model_relation IS '';


-- CREATE UNIQUE INDEX PRIMARY ON act_de_model_relation(id);
CREATE INDEX fk_relation_child ON act_de_model_relation(model_id);
CREATE INDEX fk_relation_parent ON act_de_model_relation(parent_model_id);