Error executing jbpm.jpdl.mysql.sql

[rodosa]

Hello!

I've a problem building a database in mysql. I've instaled :

jbpm-jpdl-3.2.2
jdk1.6.0_03
MySQL Server 6.0

When I execute the jbpm.jpdl.mysql.sql file to build my DB it doesn't work. I append the semicolon in each line but this is the error that occurs always while the execution.

 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'type=
InnoDB' at line 1

How can I fix it? Thanks

[kukeltje]

add an ; to the end of each line

[rodosa]

I have the ';' at the end of each line but .. it doesn't work

[kukeltje]

hmmm... sorry, I now see you use mysql 6... not sure jBPM has ever been tested with this. If hibernate supports mysql 6, it might work, but the ddl will probably not be correct.. there might be differences there

[rodosa]

I also try with MySQL 5.1 but it doesn't work. I've read that with MySQL 5.0, jbpm has problems. Now I'm using with MySQL 4.1 and it seems that work!

Is MySQL 4.1 the last version that it has been tested with jbpm?

[rainhust]

try change the type=InnoDB
to

engine=InnoDB

[rodosa]

I've just try this (changing type=InnoDB for engine=InnoDB) in MySQL 6.0 but it' doesn't work

[kukeltje]

5 should work as well. it`does here