[ http://jira.jboss.com/jira/browse/JBMESSAGING-683?page=all ] Markus Lutum updated JBMESSAGING-683: ------------------------------------- Summary: MSSQL configuration appears invalid (was: CLONE -MSSQL configuration appears invalid) JBoss Forum Reference: (was: http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3975994#...) Affects Version/s: 1.2.0.Alpha1 (was: 1.0.1.CR5) Description: The MSSQL persistence manager config appears to be invalid. One call inside the mssql-persistence-service.xml must be changed UPDATE_UNRELIABLE_CHANNELCOUNT=UPDATE JMS_MESSAGE M SET M.CHANNELCOUNT = M.CHANNELCOUNT - 1 WHERE M.MESSAGEID IN (SELECT MR.MESSAGEID FROM JMS_MESSAGE_REFERENCE MR WHERE MR.RELIABLE = 'N' AND MR.CHANNELID = ?) should be UPDATE_UNRELIABLE_CHANNELCOUNT=UPDATE JMS_MESSAGE SET CHANNELCOUNT = CHANNELCOUNT - 1 WHERE MESSAGEID IN (SELECT MR.MESSAGEID FROM JMS_MESSAGE_REFERENCE MR WHERE MR.RELIABLE = 'N' AND MR.CHANNELID = ?) (without M) was: The MSSQL persistence manager config appears to be invalid. This needs to be tested with the entire functional tests suite. -- 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

[ http://jira.jboss.com/jira/browse/JBMESSAGING-683?page=all ] Ovidiu Feodorov updated JBMESSAGING-683: ---------------------------------------- Fix Version/s: 1.2.0.CR1 -- 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