[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