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. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4259518#4259518 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4259518 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
