Gary Struthers [http://community.jboss.org/people/GaryS] created the discussion
"Re: TaskService Referential integrity constraint violation" To view the discussion, visit: http://community.jboss.org/message/621151#621151 -------------------------------------------------------------- Hi Mauricio, I've tried adding various users and groups to the TaskServiceSession. If I don't have an Administrator Hibernate: insert into PeopleAssignments_BAs (task_id, entity_id) values (?, ?) fails. But, for me that inserts fine and so does the first potential owner. Hibernate: insert into PeopleAssignments_BAs (task_id, entity_id) values (?, ?) Hibernate: insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?) But then it updates the session and that begins the constraint violation Hibernate: update SessionInfo set lastModificationDate=?, rulesByteArray=?, startDate=?, OPTLOCK=? where id=? and OPTLOCK=? 0 14/08 12:33:53,996[NioProcessor-1] ERROR hibernate.util.JDBCExceptionReporter.logExceptions - Referential integrity constraint violation: "FK1EE418D2C122ED2: PUBLIC.PEOPLEASSIGNMENTS_POTOWNERS FOREIGN KEY(ENTITY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement: insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?) [23002-128] 5 14/08 12:33:54,001[NioProcessor-1] ERROR hibernate.util.JDBCExceptionReporter.logExceptions - Referential integrity constraint violation: "FK1EE418D2C122ED2: PUBLIC.PEOPLEASSIGNMENTS_POTOWNERS FOREIGN KEY(ENTITY_ID) REFERENCES PUBLIC.ORGANIZATIONALENTITY(ID)"; SQL statement: insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?) [23002-128] 7 14/08 12:33:54,003[NioProcessor-1] ERROR event.def.AbstractFlushingEventListener.performExecutions - Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/621151#621151] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
