Hi,
i have an error when deleting a process instance using this line code :
runtimeAPI.deleteProcessInstance(processInstanceUUID);
the nova_xpdl_exec table contains those rows
DBID_ INSTANCE_ PARENT_ PROCESS_ XPDL_INSTANCE_
1 1 NULL 4 1
2 1 1 4 1
[ERROR] JDBCExceptionReporter - Cannot delete or update a parent row: a foreign
key constraint fails (`bonita`.`nova_xpdl_exec`, CONSTRAINT `FK_XPDL_EXEC_INST`
FOREIGN KEY (`INSTANCE_`) REFERENCES `nova_xpdl_exec` (`DBID_`))
FOREIGN KEY (`INSTANCE_`) REFERENCES `nova_xpdl_exec` (`DBID_`))
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
Apparently, the constraint failure is caused by first row suppression whithout
deleting the second one first.
Is it API limitation ?
How should I use the runtimeAPI to delete process instances ?
thanks a lot
--
You receive this message as a subscriber of the
bonita@... mailing list.
To unsubscribe: mailto:
bonita-unsubscribe@...
For general help: mailto:
sympa@...?subject=help
OW2 mailing lists service home page:
http://www.ow2.org/wws
