[jboss-user] [jBPM] - Constraint query
Steve Howie
do-not-reply at jboss.com
Wed May 12 17:20:25 EDT 2010
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&containerType=14&container=2034]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100512/00ea54d6/attachment-0001.html
More information about the jboss-user
mailing list