I am trying to delete a few related records from a few of the JBPM table.
I was trying to delete a few records from JBPM_process instance and some related records in JBPM_Token.
I'm hitting constraints on each table that won't let me delete from either.
I'm not sure it's possible but I am trying to find a solution that doesn't measn I have to drop the constraints. How does graphSession.deleteProcessInstance accomplish it?
PROMPT ALTER TABLE jbpm_processinstance ADD CONSTRAINT fk_procin_roottkn FOREIGN KEY
ALTER TABLE jbpm_processinstance
ADD CONSTRAINT fk_procin_roottkn FOREIGN KEY (
roottoken_
) REFERENCES jbpm_token (
id_
)
/
PROMPT ALTER TABLE jbpm_token ADD CONSTRAINT fk_token_procinst FOREIGN KEY
ALTER TABLE jbpm_token
ADD CONSTRAINT fk_token_procinst FOREIGN KEY (
processinstance_
) REFERENCES jbpm_processinstance (
id_
)