jbpm 4中快速删除JBPM自带数据表数据的语句

HEERY 2013-06-29

jbpm4中,由于其自带表的关联性,有时在测试时,手工删除很麻烦,可以用如下的一组语句 
去删除了 

delete from jbpm4_variable; 

delete from jbpm4_task; 

delete from jbpm4_property; 

delete from jbpm4_lob; 

delete from jbpm4_hist_actinst; 

delete from jbpm4_hist_procinst; 

delete from jbpm4_hist_task; 

delete from jbpm4_deployprop; 

delete from jbpm4_deployment; 

update jbpm4_execution set instance_=null; 

delete from jbpm4_execution;

相关推荐