I am trying to delete a somerelated records from a few of the JBPM tables (not all, no cascade or destroyCase).
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. Same if I try to update to change fk data.
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?
delete from JBPM_ProcessInstance where id_=1234
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_
)
/
delete from jbpm_token where id_=1235
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_
)