Steve Howie [http://community.jboss.org/people/airomega] created the discussion "Constraint query" To view the discussion, visit: http://community.jboss.org/message/542721#542721 -------------------------------------------------------------- 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_ ) -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/542721#542721] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]