[jboss-user] [JBoss jBPM] - Re: Unable to insert new process definitions.

[kinshuk_in]

This did'nt work for me, both for ISASYNC_ and all other bit columns. No matter which version and driver I used on mySQL. What worked was changing all the bit fields in mysql to tinyint(1). This issue is probably due to - http://jira.jboss.com/jira/browse/BPEL-182 or http://jira.jboss.com/jira/browse/JBPM-443

sticking the ALTER script here :...

ALTER TABLE JBPM_PROCESSDEFINITION MODIFY ISTERMINATIONIMPLICIT_ TINYINT(1);
ALTER TABLE JBPM_ACTION MODIFY ISASYNC_ TINYINT(1);
ALTER TABLE JBPM_ACTION MODIFY ISPROPAGATIONALLOWED_ TINYINT(1);
ALTER TABLE JBPM_NODE MODIFY ISASYNC_ TINYINT(1);
ALTER TABLE JBPM_NODE MODIFY ISASYNCEXCL_ TINYINT(1);
ALTER TABLE JBPM_NODE MODIFY CREATETASKS_ TINYINT(1);
ALTER TABLE JBPM_NODE MODIFY ENDTASKS_ TINYINT(1);
ALTER TABLE JBPM_PROCESSINSTANCE MODIFY ISSUSPENDED_ TINYINT(1);
ALTER TABLE JBPM_TASK MODIFY ISBLOCKING_ TINYINT(1);
ALTER TABLE JBPM_TASK MODIFY ISSIGNALLING_ TINYINT(1);    
ALTER TABLE JBPM_TASKINSTANCE MODIFY ISCANCELLED_ TINYINT(1); 
ALTER TABLE JBPM_TASKINSTANCE MODIFY ISSUSPENDED_ TINYINT(1); 
ALTER TABLE JBPM_TASKINSTANCE MODIFY ISOPEN_ TINYINT(1); 
ALTER TABLE JBPM_TASKINSTANCE MODIFY ISSIGNALLING_ TINYINT(1); 
ALTER TABLE JBPM_TASKINSTANCE MODIFY ISBLOCKING_ TINYINT(1); 
ALTER TABLE JBPM_TOKEN MODIFY ISABLETOREACTIVATEPARENT_ TINYINT(1); 
ALTER TABLE JBPM_TOKEN MODIFY ISTERMINATIONIMPLICIT_ TINYINT(1); 
ALTER TABLE JBPM_TOKEN MODIFY ISSUSPENDED_ TINYINT(1);

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4079279#4079279

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4079279