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

[Chris OBrien (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBPM-593?page=comments#action_12339524 ] 
            
Chris OBrien commented on JBPM-593:
-----------------------------------

I am using jBPM 3.1.1, and have tried both the Hibernate3.jar that comes with jBPM as well as a Self built Hibernate 3.1.2 jar, and I do not have this issue at all.  I can suspend and resume messages with the original queries (I checked) with no issue.

Windows XP, JDK 1.4.2_06, jBPM 3.1.1

> 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.2
>
>
> 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