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:
<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'. Can someone confirm if I have indeed presented the fix or am I missing something here? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3931527#3931527 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3931527 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user