[jboss-user] [JBoss jBPM] - Re: jBPM : Couldn't be that complicated...
do-not-reply at jboss.com
Tue Mar 27 16:50:56 EDT 2007
"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
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
More information about the jboss-user