"kukeltje" wrote : did you try to run this script for updating a 3.1 database to a 3.2 database? I'm looking into this, but afaik, this is for creating a new database (even if one already exists). | | I did it several times and did not encounter these errors. It's simple, if the fk's are not deleted, you cannot drop the tables..... that is mysql behaviour. Then do a truncate first or something delete the schema and create it again... not so difficult, is it? I've worked with mysql and jbpm for 4 years now... you have to be a little creative, but just a little.
Yeah I know! I do understand the errors. What I can't understand is that why the script simply can't run out-of-the-box, this is the whole point. I don't belive the scripts located at db/jbpm-jpdl-mysql.sql are intend for fresh install are they? The miss a lot of tables when compared to the one found on starters-kit. One thing I'll do here is to mix both scripts so I don't need to rely on the alter table that seems to be problematic (I found a bug on mysql complaining about droping constraints with alter table). So far I left this behind as we are running out of time and I've already an oracle DB setup Regards View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4032198#4032198 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4032198 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
