Posted: March 08, 2013 22:34 by RuiRosado
I am learning to use Imixs Workflow. Following the 'getting started' instructions, I can deploy and use the imixs-workflow-web-sample-0.0.7 on GlassFish with JavaDB/Derby. When I try to use a MySQL database backend, I can start the web-application, but when I create a 'ticket' it will not save, throwing an exception with root-cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails ("workflow"."entity_textitem", CONSTRAINT "FK_ENTITY_TEXTITEM_textItems_ID" FOREIGN KEY ("textItems_ID") REFERENCES "textitem" ("ID"))
(I am not including the whole stacktrace here).
Thanks in advance,