3 Replies Latest reply on Oct 9, 2009 12:37 PM by Ronald van Kuijk

    Weird schema generation in 3.3.1.GA version

    Eman Nollase Newbie

      Hello,

      I just recently updated from jbpm 3.2.x to 3.3.1.GA. Now when i try to copy paste the hibernate.cfg.mysql.xml to my own hibernate config i get this error:

      13:55:58,687 ERROR - SchemaExport - Unsuccessful: create table JBPM_ACTION (ID_ bigint generated by default as identity (start with 1), class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ longvarchar, TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
      13:55:58,687 ERROR - SchemaExport - 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 'generated by default as identity (start with 1), class char(1) not null, NAME_ v' at line 1
      13:55:58,688 ERROR - SchemaExport - Unsuccessful: create table JBPM_BYTEARRAY (ID_ bigint generated by default as identity (start with 1), NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_))
      13:55:58,688 ERROR - SchemaExport - 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 'generated by default as identity (start with 1), NAME_ varchar(255), FILEDEFINIT' at line 1
      13:55:58,744 ERROR - SchemaExport - Unsuccessful: create table JBPM_COMMENT (ID_ bigint generated by default as identity (start with 1), VERSION_ integer not null, ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ longvarchar, TOKEN_ bigint, TASKINSTANCE_ bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key (ID_))
      13:55:58,744 ERROR - SchemaExport - 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 'generated by default as identity (start with 1), VERSION_ integer not null, ACTO' at line 1
      13:55:58,797 ERROR - SchemaExport - Unsuccessful: create table JBPM_DELEGATION (ID_ bigint generated by default as identity (start with 1), CLASSNAME_ longvarchar, CONFIGURATION_ longvarchar, CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ bigint, primary key (ID_))
      13:55:58,797 ERROR - SchemaExport - 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 'generated by default as identity (start with 1), CLASSNAME_ longvarchar, CONFIGU' at line 1
      13:55:58,798 ERROR - S
      ..........................................................

      some table are not created. of course the user is (root). but when i point the configlocation the one in jbpm-jpdl.config.jar it work fine.

      my worry is that every time i stop/start my server i will create always the tables becuase of this:

      create

      ...

      how can solve this?

      thanks a lot.
      cheers.