[jboss-user] [jBPM] - I have same problems when i user Human Task on MYSQL

[losfa jon]

losfa jon [http://community.jboss.org/people/sd1527907] created the discussion

"I have same problems when i user Human Task on MYSQL"

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

--------------------------------------------------------------
hi 
first i start my Server and add a new user (customer);
and it works ok
but when i use Client to start a process 
it throws a sql error
that is 
Hibernate: select user_.id from OrganizationalEntity user_ where user_.id=?
Hibernate: insert into Task (allowedToDelegate, taskInitiator_id, priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType, documentContentId, documentType, expirationTime, faultAccessType, faultContentId, faultName, faultType, outputAccessType, outputContentId, outputType, parentId, previousStatus, processInstanceId, skipable, status, workItemId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into Content (content) values (?)
Hibernate: update Task set allowedToDelegate=?, taskInitiator_id=?, priority=?, activationTime=?, actualOwner_id=?, createdBy_id=?, createdOn=?, documentAccessType=?, documentContentId=?, documentType=?, expirationTime=?, faultAccessType=?, faultContentId=?, faultName=?, faultType=?, outputAccessType=?, outputContentId=?, outputType=?, parentId=?, previousStatus=?, processInstanceId=?, skipable=?, status=?, workItemId=? where id=?
Hibernate: insert into PeopleAssignments_BAs (task_id, entity_id) values (?, ?)
28-10-11 afternoon 04:01 org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 1452, SQLState: 23000
28-10-11 afternoon 04:01 org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Cannot add or update a child row: a foreign key constraint fails (`jbpm5`.`peopleassignments_bas`, CONSTRAINT `FK9D8CF4EC2C122ED2` FOREIGN KEY (`entity_id`) REFERENCES `organizationalentity` (`id`))

it happen becouse of the Table Task is null

but on the log  sql   
Hibernate: insert into Task (allowedToDelegate, taskInitiator_id, priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType, documentContentId, documentType, expirationTime, faultAccessType, faultContentId, faultName, faultType, outputAccessType, outputContentId, outputType, parentId, previousStatus, processInstanceId, skipable, status, workItemId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

the task has insert into values 

so i don.t know how to do it 
if someone who know please help me 
thanks
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/634008#634008]

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/20111028/c12d078d/attachment.html