[jboss-user] [jBPM] - Constraint query

[Dave McLachlan]

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&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100512/ab712c06/attachment-0001.html