"michea" wrote : To create the tables, I used the script given with 3.2 GA after : | - removing the firsts ALTER TABLE instructions | - adding ";" at the end of each line | | It seems to work, for the login/pass I just uses a properties file. | | We are still struggling with transactions and transitions, as we have different behaviours depending on the machine. | I start to guess that 4.0.5GA + EJB3 might have some bug in redeployment, often I have to delete the content of server/tmp to deploy correctly. | | A jboss4.0.5+EJB3 bundled with JBPM... would be great in the suite.
Well, I really give up mysql here. Here's what I've done, step by step and it did not work in 4 different versions of mySQL (4.0.28,4.1.23,5.0.24a,5.1.7). Ran the examples located at starterskit 3.1.3 (I run the ant tasks to create the scripts for mySQL) Ran the scripts of 3.2 under db (removed the alter tables...) Here's the result: | mysql> source jbpm.jpdl.mysql.sql; | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | Query OK, 0 rows affected (0.00 sec) | | Query OK, 0 rows affected (0.06 sec) | | Query OK, 0 rows affected (0.00 sec) | | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | Query OK, 0 rows affected, 1 warning (0.00 sec) | | Query OK, 0 rows affected (0.03 sec) | | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | Query OK, 0 rows affected (0.01 sec) | | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | Query OK, 0 rows affected (0.03 sec) | | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails | Query OK, 0 rows affected (0.01 sec) | | Query OK, 0 rows affected (0.03 sec) | | ERROR 1050 (42S01): Table 'JBPM_ACTION' already exists | ERROR 1050 (42S01): Table 'JBPM_BYTEARRAY' already exists | Query OK, 0 rows affected, 1 warning (0.14 sec) | | Query OK, 0 rows affected, 1 warning (0.07 sec) | | Query OK, 0 rows affected, 1 warning (0.11 sec) | | ERROR 1050 (42S01): Table 'JBPM_DELEGATION' already exists | ERROR 1050 (42S01): Table 'JBPM_EVENT' already exists | ERROR 1050 (42S01): Table 'JBPM_EXCEPTIONHANDLER' already exists | Query OK, 0 rows affected, 1 warning (0.09 sec) | | Query OK, 0 rows affected, 1 warning (0.10 sec) | | ERROR 1050 (42S01): Table 'JBPM_MODULEDEFINITION' already exists | ERROR 1050 (42S01): Table 'JBPM_MODULEINSTANCE' already exists | ERROR 1050 (42S01): Table 'JBPM_NODE' already exists | ERROR 1050 (42S01): Table 'JBPM_POOLEDACTOR' already exists | ERROR 1050 (42S01): Table 'JBPM_PROCESSDEFINITION' already exists | ERROR 1050 (42S01): Table 'JBPM_PROCESSINSTANCE' already exists | Query OK, 0 rows affected, 1 warning (0.08 sec) | | ERROR 1050 (42S01): Table 'JBPM_SWIMLANE' already exists | ERROR 1050 (42S01): Table 'JBPM_SWIMLANEINSTANCE' already exists | ERROR 1050 (42S01): Table 'JBPM_TASK' already exists | Query OK, 0 rows affected, 1 warning (0.05 sec) | | ERROR 1050 (42S01): Table 'JBPM_TASKCONTROLLER' already exists | ERROR 1050 (42S01): Table 'JBPM_TASKINSTANCE' already exists | ERROR 1050 (42S01): Table 'JBPM_TOKEN' already exists | ERROR 1050 (42S01): Table 'JBPM_TOKENVARIABLEMAP' already exists | ERROR 1050 (42S01): Table 'JBPM_TRANSITION' already exists | Query OK, 0 rows affected, 1 warning (0.10 sec) | | Query OK, 0 rows affected, 1 warning (0.09 sec) | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_ACTION_EVENT' | ERROR 1061 (42000): Duplicate key name 'FK_ACTION_EXPTHDL' | ERROR 1061 (42000): Duplicate key name 'FK_ACTION_PROCDEF' | ERROR 1061 (42000): Duplicate key name 'FK_CRTETIMERACT_TA' | ERROR 1061 (42000): Duplicate key name 'FK_ACTION_ACTNDEL' | ERROR 1061 (42000): Duplicate key name 'FK_ACTION_REFACT' | ERROR 1061 (42000): Duplicate key name 'FK_BYTEARR_FILDEF' | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.11 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.17 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.11 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_DELEGATION_PRCD' | ERROR 1061 (42000): Duplicate key name 'FK_EVENT_PROCDEF' | ERROR 1061 (42000): Duplicate key name 'FK_EVENT_NODE' | ERROR 1061 (42000): Duplicate key name 'FK_EVENT_TRANS' | ERROR 1061 (42000): Duplicate key name 'FK_EVENT_TASK' | Query OK, 0 rows affected (0.11 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.17 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.65 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.18 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.18 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.18 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.18 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.17 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_TSKDEF_START' | ERROR 1061 (42000): Duplicate key name 'FK_MODDEF_PROCDEF' | Query OK, 0 rows affected (0.12 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_TASKMGTINST_TMD' | ERROR 1061 (42000): Duplicate key name 'FK_MODINST_PRCINST' | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_PROCST_SBPRCDEF' | ERROR 1061 (42000): Duplicate key name 'FK_NODE_PROCDEF' | ERROR 1072 (42000): Key column 'SCRIPT_' doesn't exist in table | ERROR 1061 (42000): Duplicate key name 'FK_NODE_ACTION' | ERROR 1061 (42000): Duplicate key name 'FK_DECISION_DELEG' | ERROR 1061 (42000): Duplicate key name 'FK_NODE_SUPERSTATE' | ERROR 1061 (42000): Duplicate key name 'IDX_PLDACTR_ACTID' | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_POOLEDACTOR_SLI' | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_PROCDEF_STRTSTA' | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_PROCIN_PROCDEF' | ERROR 1061 (42000): Duplicate key name 'FK_PROCIN_ROOTTKN' | ERROR 1061 (42000): Duplicate key name 'FK_PROCIN_SPROCTKN' | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.17 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.42 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_SWL_ASSDEL' | ERROR 1061 (42000): Duplicate key name 'FK_SWL_TSKMGMTDEF' | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_SWIMLANEINST_TM' | ERROR 1061 (42000): Duplicate key name 'FK_SWIMLANEINST_SL' | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.18 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_TSK_TSKCTRL' | ERROR 1061 (42000): Duplicate key name 'FK_TASK_ASSDEL' | ERROR 1061 (42000): Duplicate key name 'FK_TASK_TASKNODE' | ERROR 1061 (42000): Duplicate key name 'FK_TASK_PROCDEF' | ERROR 1061 (42000): Duplicate key name 'FK_TASK_STARTST' | ERROR 1061 (42000): Duplicate key name 'FK_TASK_TASKMGTDEF' | ERROR 1061 (42000): Duplicate key name 'FK_TASK_SWIMLANE' | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_TSKCTRL_DELEG' | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1072 (42000): Key column 'PROCINST_' doesn't exist in table | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'IDX_TASK_ACTORID' | ERROR 1072 (42000): Key column 'PROCINST_' doesn't exist in table | ERROR 1061 (42000): Duplicate key name 'FK_TASKINST_TMINST' | ERROR 1061 (42000): Duplicate key name 'FK_TASKINST_TOKEN' | ERROR 1061 (42000): Duplicate key name 'FK_TASKINST_SLINST' | ERROR 1061 (42000): Duplicate key name 'FK_TASKINST_TASK' | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.27 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.17 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_TOKEN_PARENT' | ERROR 1061 (42000): Duplicate key name 'FK_TOKEN_NODE' | ERROR 1061 (42000): Duplicate key name 'FK_TOKEN_PROCINST' | ERROR 1061 (42000): Duplicate key name 'FK_TOKEN_SUBPI' | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_TKVARMAP_CTXT' | ERROR 1061 (42000): Duplicate key name 'FK_TKVARMAP_TOKEN' | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR 1061 (42000): Duplicate key name 'FK_TRANSITION_TO' | ERROR 1061 (42000): Duplicate key name 'FK_TRANS_PROCDEF' | ERROR 1061 (42000): Duplicate key name 'FK_TRANSITION_FROM' | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.17 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.13 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.12 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.16 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.15 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | Query OK, 0 rows affected (0.14 sec) | Records: 0 Duplicates: 0 Warnings: 0 | | ERROR: | No query specified | And after all this, the tables are not updated, for instance JBPM_TASKINSTANCE does not get an VERSION_ column Well, what else am I doing wrong that I cant get it working on mysql? Oracle works pretty fine :) But ?I don't have an oracle on my machine :( hence I depend to be on my company network to run the examples I'm building... Regards View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4032150#4032150 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4032150 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
