0 Replies Latest reply on May 12, 2010 5:32 PM by Dave McLachlan

    Constraint query

    Dave McLachlan Newbie

      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_
      )