Hi Ronald,
Well, I hope you'll find time to visit us anyway. Then again, there is always next
year!
We found a solution to the problem. It's brute, but works. Basically, before, we
dropped the whole jbpm database, and then restarted jboss as, thereby recreating all
tables again. Then, I noticed which tables were empty after a fresh start, and now we just
empty those tables when needed. Here is the code:
for(String table: new String[] {"jbpm_db.jbpm_bytearray",
"jbpm_db.jbpm_byteblock", "jbpm_db.jbpm_comment",
"jbpm_db.jbpm_decisionconditions", "jbpm_db.jbpm_exceptionhandler",
"jbpm_db.jbpm_job", "jbpm_db.jbpm_log",
"jbpm_db.jbpm_moduleinstance", "jbpm_db.jbpm_pooledactor",
"jbpm_db.jbpm_processinstance", "jbpm_db.jbpm_runtimeaction",
"jbpm_db.jbpm_swimlaneinstance", "jbpm_db.jbpm_taskactorpool",
"jbpm_db.jbpm_taskcontroller", "jbpm_db.jbpm_taskinstance",
"jbpm_db.jbpm_token", "jbpm_db.jbpm_tokenvariablemap",
"jbpm_db.jbpm_variableaccess", "jbpm_db.jbpm_variableinstance"}) {
DbUtils.emptyTable(em, table);
}
and in DBUtils.java:
public static void emptyTable(EntityManager em, String tableName) {
Query query = em.createNativeQuery("delete from " + tableName);
query.executeUpdate();
}
Luckily we didn't run into foreign key integrity issues.
We really need to remove all process data from the jbpm database, since we also empty our
domain database, and any references to our domain model in jbpm will not be valid
anymore.
Thanks for the suggestion, and good luck with your startup! I hope it will be fun :)
Greg
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4167674#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...