[jboss-jira] [JBoss JIRA] Closed: (JBMESSAGING-683) MSSQL configuration appears invalid

MSSQL configuration appears invalid ----------------------------------- Key: JBMESSAGING-683 URL: http://jira.jboss.com/jira/browse/JBMESSAGING-683 Project: JBoss Messaging Issue Type: Bug Affects Versions: 1.2.0.Alpha1 Reporter: Markus Lutum Assigned To: Tim Fox Fix For: 1.2.0.CR1 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)