[jboss-jira] [JBoss JIRA] Closed: (JBPM-593) suspend() and resume() failing in JBPM 3.1

[Tom Baeyens (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBPM-593?page=all ]

Tom Baeyens closed JBPM-593.
----------------------------

    Resolution: Done

i applied the proposed updates and introduced the message alias.

> suspend() and resume() failing in JBPM 3.1
> ------------------------------------------
>
>                 Key: JBPM-593
>                 URL: http://jira.jboss.com/jira/browse/JBPM-593
>             Project: JBoss jBPM
>          Issue Type: Bug
>          Components: Core Engine
>    Affects Versions: jBPM 3.1
>         Environment: Windows XP Pro, JDK 1.5.0_06, jBPM 3.1
>            Reporter: Romin Irani
>         Assigned To: Tom Baeyens
>            Priority: Blocker
>             Fix For: jBPM 3.1.3
>
>
> The resume() and suspend() methods on the ProcessInstance are failing in jBPM 3.1. The resume() and suspend() methods on the ProcessInstance are failing in jBPM 3.1. The error is a SQL Syntax error "unknown column 'token'". On debugging, I have found the following named queries in the org/jbpm/db/hibernate.queries.hbm.xml as given below: 
> Code: 
> <query name="MessagingSession.suspendMessagesForToken">
>     <![CDATA[
>       update org.jbpm.msg.Message
>       set isSuspended = true
>       where token = :token
>     ]]>
>   </query>
>   <query name="MessagingSession.resumeMessagesForToken">
>     <![CDATA[
>       update org.jbpm.msg.Message 
>       set isSuspended = false
>       where token = :token
>     ]]>
>   </query>
> On changing them to the following
> <query name="MessagingSession.suspendMessagesForToken">
>     <![CDATA[
>       update org.jbpm.msg.Message m
>       set m.isSuspended = true
>       where m.token = :token
>     ]]>
>   </query>
>   <query name="MessagingSession.resumeMessagesForToken">
>     <![CDATA[
>       update org.jbpm.msg.Message m
>       set m.isSuspended = false
>       where m.token = :token
>     ]]>
>   </query>	 
> and replacing the file in JBPM JAR file, it worked. Note : I added the alias 'm'. 
> This is happening with the Hibernate JAR's that are shipped with JBPM 3.1 itself. I have not tried it out with Hibernate 3.1 standalone downloaded directly  from the Hibernate site. 

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