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#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...