If my synchronously invoked action class (on node-enter event) throws exception, I cannot delete particular process instance after that:
[executive] WARN [http-8180-Processor25] JDBCExceptionReporter.logExceptions(71) | SQL Error: 1451, SQLState: 23000 | [executive] ERROR [http-8180-Processor25] JDBCExceptionReporter.logExceptions(72) | Cannot delete or update a parent row: a foreign key cons | traint fails (`executive_db/jbpm_variableinstance`, CONSTRAINT `FK_VARINST_PRCINST` FOREIGN KEY (`PROCESSINSTANCE_`) REFERENCES `jbpm_proces | sinstance` (`ID_`)) | [executive] ERROR [http-8180-Processor25] AbstractFlushingEventListener.performExecutions(301) | Could not synchronize database state with s | ession | org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.graph.exe.ProcessInstance#1] | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) | at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2476) | at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2632) | at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:73) | at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) | at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) | at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144) | at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) | at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) | at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) | I have JBPM tables in the same DB as my app tables. They use the same Hibernate session factory. Any hint? recommended way to handle runtime exception? Thanks Milan View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4019447#4019447 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4019447 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user