JBPM中如何删除流程定义

最新推荐文章于 2025-09-03 15:58:35 发布

最新推荐文章于 2025-09-03 15:58:35 发布 · 212 阅读

文章标签：

#jbpm #JBPM中如何删除流程定义 #删除 #数据库 #jbpm数据库

JBPM 专栏收录该内容

3 篇文章

订阅专栏

本文提供了一套详细的SQL指令，用于彻底清除JBPM工作流系统中特定流程实例的历史记录，包括活动实例、变量、任务等，确保流程数据的一致性和清洁。

//删除流程历史
DELETE FROM JBPM4_HIST_ACTINST WHERE EXECUTION_ LIKE '%EX%'
DELETE FROM JBPM4_HIST_VAR where PROCINSTID_ like '%EX%';
DELETE FROM JBPM4_HIST_PROCINST WHERE ID_ LIKE '%EX%';
DELETE FROM JBPM4_HIST_TASK WHERE EXECUTION_ LIKE '%EX%' ;

DELETE FROM JBPM4_PARTICIPATION WHERE SWIMLANE_ IN (SELECT DBID_ FROM JBPM4_SWIMLANE where EXECUTION_ IN (SELECT DBID_ FROM JBPM4_EXECUTION WHERE ID_ LIKE '%EX%'));
DELETE FROM JBPM4_PARTICIPATION WHERE TASK_ IN (SELECT DBID_ FROM JBPM4_TASK WHERE EXECUTION_ IN (SELECT DBID_ FROM JBPM4_EXECUTION WHERE ID_ LIKE '%EX%'));
DELETE FROM JBPM4_TASK WHERE EXECUTION_ IN (SELECT DBID_ FROM JBPM4_EXECUTION WHERE ID_ LIKE '%EX%');
DELETE FROM JBPM4_VARIABLE WHERE EXECUTION_ IN (SELECT DBID_ FROM JBPM4_EXECUTION WHERE ID_ LIKE '%EX%');
DELETE FROM JBPM4_EXECUTION WHERE ID_ LIKE '%EX%' AND KEY_ IS NULL;
//删除jbpm4_execution自连接
UPDATE JBPM4_EXECUTION SET INSTANCE_ = NULL WHERE ID_ LIKE '%EX%';
DELETE FROM JBPM4_SWIMLANE WHERE EXECUTION_ IN (SELECT DBID_ FROM JBPM4_EXECUTION WHERE ID_ LIKE '%EX%');
DELETE FROM JBPM4_EXECUTION WHERE ID_ LIKE '%EX%';