[jboss-jira] [JBoss JIRA] Commented: (JBPM-593) suspend() and resume() failing in JBPM 3.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.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.