[jboss-user] [jBPM] - Constraint query

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