[jbpm-users] [JBoss jBPM] - Re: Trying to persist process instances - need some help

So it turns out I think I had a couple of things missing/wrong. (Of course :) ) So #1, it seems when trying to load up an external DB and use the jbpm-console there are a couple of things that should be known: a) The database build scripts located under {jbpm-install}/database do not include any of the authentication tables needed to actually use the jbpm-console web app. b) When installing jbpm through the jar installer, if you chose hypersonic as your database, it *will* however give you the correct tables needed for jbpm-console (hence why it works out of the box) So what I ended up doing was copying the SQL out of my {jboss-server}/data/hypersonic/JbpmDB.script that hypersonic was using to create the remaining tables needed for my jbpm-console to work correctly. Once I was able to get the console working correctly (knowing I had the correct DB settings and hibernate) I was able to then compare/use these settings in my own app. I'm working closer to getting it working correctly. Now I'm getting what seems to be a more manageable exception :) org.hibernate.AssertionFailure: null id in org.jbpm.graph.def.ProcessDefinition entry (don't flush the Session after an exception occurs) I'm happy though that the jbpm-console examples are working and persisting correctly to Mysql! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4200413#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...