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

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;

评论

1 楼 lydawen 2012-03-10  

truncate table岂不更好。