Hi,

I am trying to delete a processIntance using GrapSession object. What I have 
looks like

 GraphSession session = context.getGraphSession();
                    ProcessInstance processInstance = null;
                    if (session != null) {
                        processInstance = 
session.getProcessInstance(processInstanceId);
                        if (processInstance != null) {
                            session.deleteProcessInstance(processInstance);
                        }
                    }

When I do this i get a hibernate exception.


org.springframework.dao.DataIntegrityViolationException: Hibernate operation: 
Could not execute JDBC batch update; SQL [delete from JBPM_MODULEINSTANCE where 
ID_=?]; Cannot delete or update a parent row: a foreign key constraint fails 
(`forms/jbpm_swimlaneinstance`, CONSTRAINT `FK_SWIMLANEINST_TM` FOREIGN KEY 
(`TASKMGMTINSTANCE_`) REFERENCES `jbpm_moduleinstance` (`ID_`)); nested 
exception is java.sql.BatchUpdateException: Cannot delete or update a parent 
row: a foreign key constraint fails (`forms/jbpm_swimlaneinstance`, CONSTRAINT 
`FK_SWIMLANEINST_TM` FOREIGN KEY (`TASKMGMTINSTANCE_`) REFERENCES 
`jbpm_moduleinstance` (`ID_`))
java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign 
key constraint fails (`forms/jbpm_swimlaneinstance`, CONSTRAINT 
`FK_SWIMLANEINST_TM` FOREIGN KEY (`TASKMGMTINSTANCE_`) REFERENCES 
`jbpm_moduleinstance` (`ID_`))

am I missing something?

thanks

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4072248#4072248

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4072248
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to