[jbpm-issues] [JBoss JIRA] Commented: (JBPM-2607) org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user

[Tom Baeyens (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBPM-2607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12503292#action_12503292 ] 

Tom Baeyens commented on JBPM-2607:
-----------------------------------

koen, if solving this requires more then the proposed change of a few lines, sync with me about it.  also make sure that you put the issue number correctly in all commit comments for easy traceability.  and sync with me after you've committed.  i want to review the fix for this issue.

> org.hibernate.NonUniqueResultException when task completion results in the assignment of a subsequent task to the same user
> ---------------------------------------------------------------------------------------------------------------------------
>
>                 Key: JBPM-2607
>                 URL: https://jira.jboss.org/jira/browse/JBPM-2607
>             Project: jBPM
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Runtime Engine
>    Affects Versions: jBPM 4.1
>         Environment: OS: Mac OS X 10.6
> java version "1.6.0_15"
> Java(TM) SE Runtime Environment (build 1.6.0_15-b03-219)
> Java HotSpot(TM) 64-Bit Server VM (build 14.1-b02-90, mixed mode)
> DB: MySQL 5 and HSQL
>            Reporter: Nils Preusker
>            Assignee: Koen Aers
>             Fix For: jBPM 4.4
>
>         Attachments: MultipleTasksTest.java, process.jpdl.xml
>
>
> The exception occurs when two subsequent tasks are both assigned to the same person and the second task contains a notification node. When the first task is completed, the MailListener will use the findTaskByExecution method of DbSessionImpl.java, which in turn queries the database for tasks by execution. I'm not sure if accidentally two instances of the same task are inserted into the database or if the previous task is not yet removed, but the query apparently returns two results, so the "uniqueResult()" call throws a NonUniqueResultException.
> (See attached process and unit test for details, this can also be found in the forum at  http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4262559#4262559)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira