[jboss-user] [jBPM] - TaskService Referential integrity constraint violation

[Gary Struthers]

Gary Struthers [http://community.jboss.org/people/GaryS] created the discussion

"TaskService Referential integrity constraint violation"

To view the discussion, visit: http://community.jboss.org/message/620882#620882

--------------------------------------------------------------
I wondered why there are examples of session persistence and separate examples of TaskServer but none I can find of both of them together.
I'm still trying to make them work together and  it's still problematic. I start the taskServer with 
<persistence-unit name="org.drools.task"> then, in main, I create 
<persistence-unit name="org.drools.persistence.jpa" transaction-type="JTA"> with a fully qualified classname for 
org.jbpm.persistence.processinstance.ProcessInstanceInfo

But when I start the process

Hibernate: insert into PeopleAssignments_BAs (task_id, entity_id) values (?, ?)
Hibernate: insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?)
0    12/08 12:40:18,491[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    12/08 12:40:18,496[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]
Hibernate: update ProcessInstanceInfo set lastModificationDate=?, lastReadDate=?, processId=?, processInstanceByteArray=?, startDate=?, state=?, OPTLOCK=? where InstanceId=? and OPTLOCK=?
13   12/08 12:40:18,504[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/620882#620882]

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/20110812/59743bc4/attachment-0001.html